How to run SSIS without using dtexec nor xp_cmdshell
-
hello everybody, I execute dts package by using these following methods in store procedure ---
sp_OACreate 'DTS.Package' --- create object
sp_OAMethod --- loads the dts package
sp_OASetProperty --- set package property
sp_OAMethod --- Executes package
sp_OADestroy --- Destroy package
in sql server 2000
BUT , now in sql server 2005, dts are replace by ssis packages..
Can I get SSIS executed by the same methods? Or any other way??
Please help 🙁
-
While I'm not adept at it, I'm sure SMO has an object you can call...
and who knows, it may be the same object call as you're using now.
Have you tried it?
Watch my free SQL Server Tutorials at:
http://MidnightDBA.com
Blog Author of:
DBA Rant – http://www.MidnightDBA.com/DBARantMinion Maintenance is FREE:
-
Hi I think I have tried with the same commands in order to execute a SSIS but I can' get it to work please any suggestions?
-
Have you tried using
Exec master..xp_cmdshell 't1*.dtsx'
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply