Question

C#调用SSIS包，包变量赋值

using DtsRunTime = Microsoft.SqlServer.Dts.Runtime.Wrapper;
public int runPackage(string Date, string Operator)
{
DtsRunTime.Application application = new DtsRunTime.Application();
DtsRunTime.IDTSPackage90 package = application.LoadPackage(packagePath, true, null);
package.Configurations["Date"].ConfigurationString = Date;
package.Configurations["FilePath"].ConfigurationString = filePath+fileName;
package.Configurations["Operator"].ConfigurationString = Operator;
DtsRunTime.DTSExecResult result = package.Execute();
if (result.Equals(DtsRunTime.DTSExecResult.DTSER_SUCCESS))
{ return 0; }
else { return 10; }
}
这种调用SSIS包的方法到底怎么给变量赋值？package.Configurations["Date"].ConfigurationString = Date;这种会报错，我没找到类似的例子，希望得到帮助

Answer 1

试试这种：
pkg.Variables["Date"].Value=Date;
pkg.Variables["FilePath"].Value=filePath+fileName;;
pkg.Variables["Operator"].Value=Operator;