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
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
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