SSIS 包创建 Hresult 0x80004005 说明 “登录超时已过期”错误

处理 SSIS 包中的 Hresult: 0x80004005 错误：“登录超时已过期”

csharp
using System;
using Microsoft.SqlServer.Dts.Runtime;
class Program
{
    static void Main()
    {
        // 创建 SSIS 应用程序对象
        Application app = new Application();
        // 加载 SSIS 包
        Package pkg = app.LoadPackage(@"C:%%Path%%To%%Your%%Package.dtsx", null);
        // 设置包的连接字符串
        ConnectionManager connectionManager = pkg.Connections["YourConnectionManager"];
        connectionManager.ConnectionString = "Data Source=YourServer;Initial Catalog=YourDatabase;User ID=YourUsername;Password=YourPassword";
        try
        {
            // 执行 SSIS 包
            DTSExecResult result = pkg.Execute();
            if (result == DTSExecResult.Success)
            {
                Console.WriteLine("SSIS 包执行成功！");
            }
            else
            {
                Console.WriteLine("SSIS 包执行失败！");
            }
        }
        catch (Exception ex)
        {
            Console.WriteLine("发生异常：" + ex.Message);
        }
    }
}