February 15, 2011 at 9:01 am
My version is 2008. Maybe this question sounds trivial, but I need to find a way to execute SSIS which is saved in SQL Server msdb, whether with a stored procedure or a job?
Thanks
February 15, 2011 at 9:07 am
For a job, you just pick that the step type is an SSIS package, and then tell it where the package is in the details for the job step.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
February 15, 2011 at 9:45 am
Completely agree with G on the job, calling one from a sproc is more complex and requires either using xp_cmdshell which I don't usually allow or starting the pre-defined job, like what G talked about.
If you need additional clarification please ask.
CEWII
February 15, 2011 at 10:00 am
SQL Guy 1 (2/15/2011)
My version is 2008. Maybe this question sounds trivial, but I need to find a way to execute SSIS which is saved in SQL Server msdb, whether with a stored procedure or a job?Thanks
If you need the SSIS package to be called 'on demand', I would recommend still creating a job as mentioned above, just with no schedule. Then allow a call to sp_start_job via stored proc.
As with any other time you expose administrative functions to users, be careful when you do this.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply