I am upgrading to SQL 2005. I have a VB script that calls a DTS package
(shown below). Is there a way for a VB script to call a SSIS package? I have
seen posts that mention adding a reference to
Microsoft.SqlServer.ManagedDTS.dll in VB.NET and calling
oApp.LoadFromSQLServer, but what about VB Script?

For SQL2K:
Set oPkg = CreateObject("DTS.Package2")
oPkg.LoadFromSQLServer SQLServerName, ,
,DTSSQLStgFlag_UseTrustedConnection,,,,PackageName
oPkg.Execute()

My task: I am loading file sets from several locations and need to run
different SPs based on the load success or failure. I previously used VBS for
FSO date comparisons and to copy required file sets to a load location, and
then running a package to load them. The VB Script was called using
xp_cmdshell from within a cursor loop in a SP. Any better ssis suggestions?

Here's how I ended up getting around it...

Set WSHShell = WScript.CreateObject("WScript.Shell")

intReturn = WshShell.Run("dtexec /sq pkgOne /ser productionServer",
[intWindowStype], [bWaitOnReturn])

Set WSHShell = Nothing

"Flemo" wrote: