調用SSIS

第一步：引入.NET组件 Microsoft.SQLServer.DTSRuntimeWrap Microsoft.SQLServer.ManagedDTS 第二步： 在程式的开头，加入如下语句 Imports Microsoft.SqlServer.Dts.Runtime 第三步： 調用語句 Dim app As Application = New Application Dim p As Package = app.LoadFromSqlServer("/PCEBG_CM_BI/AR_ImportHHData_001", "SSIS_SERVER", "AccountID", "PASSWORD", Nothing) p.Variables("excelname").value="" p.Variables("importdatetime").value="" ...... Dim result As Integer = p.Execute()