E:.net调用方式:
//说明需要添加 Microsoft.SqlServer.DTSPkg80.Package2Class /// <summary>
/// 运行DTS(Data Transformation Services )
/// </summary>
/// <returns></returns>
public string runDTS()
{
try
{
string returnValue; Microsoft.SqlServer.DTSPkg80.Package2Class package = new Microsoft.SqlServer.DTSPkg80.Package2Class();
string fileName = "C:\\DTStest.dts";
string password = null;
string packageID = null;
string versionID = null;
string name = "DTStest";
object pVerpersistStfOfHost = null;
package.LoadFromStorageFile(fileName,password,packageID,versionID,name,ref pVerpersistStfOfHost); package.Execute();
package.UnInitialize();
package=null;
returnValue = "success";
return returnValue; }
catch(Exception ex)
{
throw ex;
} }
//说明需要添加 Microsoft.SqlServer.DTSPkg80.Package2Class /// <summary>
/// 运行DTS(Data Transformation Services )
/// </summary>
/// <returns></returns>
public string runDTS()
{
try
{
string returnValue; Microsoft.SqlServer.DTSPkg80.Package2Class package = new Microsoft.SqlServer.DTSPkg80.Package2Class();
string fileName = "C:\\DTStest.dts";
string password = null;
string packageID = null;
string versionID = null;
string name = "DTStest";
object pVerpersistStfOfHost = null;
package.LoadFromStorageFile(fileName,password,packageID,versionID,name,ref pVerpersistStfOfHost); package.Execute();
package.UnInitialize();
package=null;
returnValue = "success";
return returnValue; }
catch(Exception ex)
{
throw ex;
} }
exec master..xp_cmdshell 'bcp database.dbo.table out (文件路劲)d:\test.xls -c -q -S"服务器" -U"用户" -P"密码"'
例子
EXEC master..xp_cmdshell ' Cttems_CheckStation.dbo.csPayTaxItems out d:\test.xls -c -q -S"192.168.0.19" -U"sa" -P"sa"'
开始复制...
1000 行成功地成批复制到主文件。总计接收: 1000
1000 行成功地成批复制到主文件。总计接收: 2000
1000 行成功地成批复制到主文件。总计接收: 3000
1000 行成功地成批复制到主文件。总计接收: 4000
NULL
已复制了 4079 行。
数据包的大小(字节): 4096
时钟时间(毫秒): 共 125
NULL--------------------
上面几个NULL值是什么意思??