January 7, 2010 at 2:45 pm
How can I launch an SSIS package from a stored procedure?
Thank you
January 7, 2010 at 2:46 pm
Any specific reason for this?
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
January 7, 2010 at 2:52 pm
I have an SSIS package that copies data from one database to another.
I want to give some users an option to run this from a asp.net web page. I wanted to create a stored procedure that can be launched from the web page that fires off the SSIS package.
Thank you!
January 7, 2010 at 4:35 pm
Create and agent job and have the stored procedure start the job.
Jeffrey Williams
Problems are opportunities brilliantly disguised as insurmountable obstacles.
How to post questions to get better answers faster
Managing Transaction Logs
January 7, 2010 at 5:33 pm
As Jeffrey suggested, have the SSIS Package scheduled as a SQL Agent job and let the Sproc kickoff the job. Let the users action (clicking a button) call that sproc.
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply