从winform c#通过命令行以编程方式运行.dtsx文件

using Microsoft.SqlServer.Dts.Runtime;

Application app = new Application();

Package package = app.LoadPackage("path/to/your/package.dtsx", null);

// 设置连接管理器
ConnectionManager connectionManager = package.Connections["YourConnectionManagerName"];
connectionManager.ConnectionString = "your_connection_string";

// 设置变量
Variables variables = package.Variables;
variables["YourVariableName"].Value = "your_value";

DTSExecResult result = package.Execute();

if (result == DTSExecResult.Success)
{
    Console.WriteLine("Package executed successfully.");
}
else
{
    Console.WriteLine("Package execution failed.");
}