使用C#调用SSIS包

使用带参数的包,首先引入
using Microsoft.SqlServer.Dts.Runtime;

然后在程序中为包变量赋值,具体方法代码:

private void runetl()
        {
            Console.WriteLine("ETL start...");
            string filepath = installedPath + "\\etl\\Package.dtsx";
            Microsoft.SqlServer.Dts.Runtime.Application application = new Microsoft.SqlServer.Dts.Runtime.Application();
            Package package = application.LoadPackage(filepath, null, true);
            package.Variables["dbservername"].Value = dwservername;
            package.Variables["dbname"].Value = dwdbname;
            package.Variables["varFolderName"].Value = thispath;
            DTSExecResult result = package.Execute();
            if (result.Equals(DTSExecResult.Success))
                listBox1.Items.Add("ETL success");
            else
            {
                listBox1.Items.Add("ETL failed");
                return;
            }
        }