首先，有两种调用方式:直接用(需要引用Microsoft.SqlServer.DTSRuntimeWrap.dll), 通过Web Service进行执行SSIS包.

如果是直接调用那么需要引用Microsoft.SqlServer.DTSRuntimeWrap.dll，客户端需要安装MS SQL 2005的客户端组件,调用的代码如下：

using System;using System.Data;using System.Collections.Generic;using System.Text;using System.Data.Common;using System.Configuration;using DtsRunTime = Microsoft.SqlServer.Dts.Runtime.Wrapper;namespace SQLHelper{    public class CallSSIS{        private string YOUR_SERVER_NAME  = ConfigurationManager.AppSettings["DTSServerName"].ToString();        private string YOUR_PACKAGE_NAME = ConfigurationManager.AppSettings["DTSPackageName"].ToString();        private string SQL_USER          = ConfigurationManager.AppSettings["DTSSQLUser"].ToString();        private string SQL_PASSWORD      = ConfigurationManager.AppSettings["DTSSQLPassword"].ToString();

/// 
        /// Run DTS for SQL 2005.        /// 
        //===============================================================        // Revision History        // Date          Author                   Description        // 12/07/2009    Terry Sun                Created        //===============================================================        public int DTSRun2005()        {                        DtsRunTime.Application dtsApplication = new DtsRunTime.Application();            // Call the .dtsx file.            //DtsRunTime.IDTSPackage90 package = dtsApplication.LoadPackage(@"c:\test.dtsx", true, null);

// Call SSIS package from SQL Server.            DtsRunTime.IDTSPackage90 package = dtsApplication.LoadFromSQLServer(                this.YOUR_PACKAGE_NAME,                 this.YOUR_SERVER_NAME,                 this.SQL_USER,                this.SQL_PASSWORD,                true,                 null);                        DtsRunTime.DTSExecResult result = package.Execute();            if (result.Equals(DtsRunTime.DTSExecResult.DTSER_SUCCESS))                return 1;            else                return 0;        }    }}