An SSIS package provides you with saved SQL Server commands that you can run on the database server. The package runs in VBScript using the Windows shell functions. The package is stored on the database server, so you use the VBScript code to load and run a package remotely or during system boot. SSIS packages contain the DTSX file extension. Set windows_shell = CreateObject(“WScript.Shell”) echo “Please wait…” lngReturnCode = shell.Run(“dtexec /f E:\package.dtsx”) echo “The SSIS package has completed.” set windows_shell = Nothing
