写了个代码,希望实现的效果是:调用SSIS包,SSIS包导入.txt文件里的数据。环境为:VS2008+SQL2005执行代码并未报错,但也没有实现理想的效果(应该是没有执行),希望大哥们帮帮我,代码如下:using Microsoft.SqlServer.Dts.Runtime;public void DTSRun2005()
{
string YOUR_SERVER_NAME = @"E:\File\cycount.dtsx";
string YOUR_PACKAGE_NAME = @"E:\File\CreditFile\smscy20100419.txt";
Microsoft.SqlServer.Dts.Runtime.Application application = new Microsoft.SqlServer.Dts.Runtime.Application();
Package package = application.LoadPackage(YOUR_SERVER_NAME, null);
package.Connections["SourceConnectionFlatFile"].ConnectionString = YOUR_PACKAGE_NAME; DTSExecResult result = package.Execute();
}
{
string YOUR_SERVER_NAME = @"E:\File\cycount.dtsx";
string YOUR_PACKAGE_NAME = @"E:\File\CreditFile\smscy20100419.txt";
Microsoft.SqlServer.Dts.Runtime.Application application = new Microsoft.SqlServer.Dts.Runtime.Application();
Package package = application.LoadPackage(YOUR_SERVER_NAME, null);
package.Connections["SourceConnectionFlatFile"].ConnectionString = YOUR_PACKAGE_NAME; DTSExecResult result = package.Execute();
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货