What is the SSIS equivilent of DTS.Package?
Posted on 2007-03-23
What is the SSIS equivilent of object DTS.Package? My goal is to execute (from within a vbscript) an SSIS package. In the "old" days, the code
Set Package = CreateObject("DTS.Package")
would do just that. How do I do this in the new SSIS world?
I have tried running dtexec in wscript.shell. I tested my command in cmd.exe, it works when executed nativly. But it will not work in wscript.shell. Any tips here?
My command is:
dtexec /sql MyPackage
My package has been stored in SQL Server.