Aug 13, 2009 #1 DickB1 Programmer Joined Aug 13, 2009 Messages 1 Location US We have a generic stored procedure to execute DTS packages. Does someone have code to do the same for a SSIS package stored in the MSDB database?
We have a generic stored procedure to execute DTS packages. Does someone have code to do the same for a SSIS package stored in the MSDB database?
Aug 13, 2009 #2 RiverGuy Programmer Joined Jul 18, 2002 Messages 5,011 Location US I would never do this, nor would I ever want to. Try to keep as much non-TSQL stuff out of stored procedures as you can. But, if you must, I suppose you could use xp_cmdshell in conjunction with the DTExec.exe executable on the server. Upvote 0 Downvote
I would never do this, nor would I ever want to. Try to keep as much non-TSQL stuff out of stored procedures as you can. But, if you must, I suppose you could use xp_cmdshell in conjunction with the DTExec.exe executable on the server.