一段调用dtsx的代码记录

 1 private void button1_Click(object sender, EventArgs e)
 2         {
 3 
 4             Microsoft.SqlServer.Dts.Runtime.Application DtsApp= new Microsoft.SqlServer.Dts.Runtime.Application();
 5             Package pack1 = DtsApp.LoadPackage(@"D:\Web\OverDue\OverDue\bin\Package1.dtsx", null);
 6             string SQL1 = SQLBuilder();
 7             pack1.Variables["MySql1"].Value=SQL1;
 8             pack1.Execute();
 9             this.Close();
10 
11         }