Con il framework 1.1 e la DLL Interop.DTS, lanciavo un DTS creato nel DB SQLServer così:
Qualcuno sa come lanciare un DTSX (versione framework 2.0) ?codice:Shared Sub EseguiDTS_Standard(ByVal NomeDTS As String, ByVal utente As String) Dim ServerDB As String = ConfigurationSettings.AppSettings("IP_DB") Dim pws As String = ConfigurationSettings.AppSettings("PWD") Dim utn As String = ConfigurationSettings.AppSettings("UTN") Dim package as New DTS.Package2 package.GlobalVariables("Utente").value = utente package.LoadFromSQLServer(ServerDB, _ utn, _ pws, _ DTSSQLServerStorageFlags.DTSSQLStgFlag_Default, _ "", _ "", _ "", _ NomeDTS) package.FailOnError = True Try package.Execute() Catch ex As Exception Throw ex Finally package.UnInitialize() package = Nothing End Try End Sub

Rispondi quotando