July 27, 2010 at 12:22 pm
Hi,
We need to run SSIS package programmatically from within a stored procedure. Is there a way to do it, like sp_... ?
Thanks
July 27, 2010 at 12:30 pm
Is the package stored as a structured file or is it stored in SQL server?
http://msdn.microsoft.com/en-us/library/ms138023.aspx explains a few options for running a package.
One of those options is dtexec.exe. If you use that, you would have to enable xp_cmdshell.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 27, 2010 at 1:22 pm
The whole reason is that we cannot use xp_cmdshell in production.
July 27, 2010 at 1:31 pm
Could you setup a SQL Agent Job to run the package, and then use sp_start_job ?
jg
July 27, 2010 at 2:44 pm
gmby (7/27/2010)
Could you setup a SQL Agent Job to run the package, and then use sp_start_job ?jg
That's probably the best bet without xp_cmdshell.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply