TIP [HTML] – Eseguire un package SQL-Server da VBS
Esempio invocazione package SQL Server da Visual Basic Script engine:
|
1 2 3 4 5 6 7 8 9 10 11 |
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 |
|
1 |
call ExecutePackage("localhost","sa", "sa", "PortingFromIB") |
