TIP [HTML] – Eseguire un package SQL-Server da VBS

Esempio invocazione package SQL Server da Visual Basic Script engine:

sub ExecutePackage(Server,UserId,UserPw,PackageName);

set objDTSPackage = CreateObject(“DTS.Package”);
objDTSPackage.LoadFromSQLServer Server, UserId,UserPw, DTSSQLStgFlag_Default, “”, “”, “”, PackageName
objDTSPackage.Execute
Set objDTSPackage = Nothing

msgbox(“Esecuzione package conclusa”)

End Sub

call ExecutePackage(“localhost”,”sa”, “sa”, “PortingFromIB”)