Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
hismightiness
Posting Yak Master
164 Posts |
 Posted - 2007-08-29 : 16:57:28
|
| I need to programmatically execute a SSIS package from a .Net application. Now, executing the SSIS package from the application directly poses permissions and software limitations with the call potentially coming from a location other than the SQL Server itself.So, it seems to me that a more obvious solution would be to create a Stored Procedure that executes the SSIS package, OR executes a Job... Which in turn would execute the SSIS package.Can anyone give me an idea or link on how to do either method? I do not need to pass in any parameters or receive them. I haven't found anything on Google yet that appears to do the trick. (Though I found a couple close examples.)- - - -- Will -- - - -http://www.strohlsitedesign.comhttp://blog.strohlsitedesign.com/http://skins.strohlsitedesign.com/ |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-30 : 00:39:30
|
| You can create a sql job for the package and execute the job with msdb..sp_start_job in your sp. |
 |
|
|
hismightiness
Posting Yak Master
164 Posts |
Posted - 2007-08-30 : 08:25:41
|
| I just knew that there would be some useful and cool SP that I forgot (or didn't know) about. Thanks!- - - -- Will -- - - -http://www.strohlsitedesign.comhttp://blog.strohlsitedesign.com/http://skins.strohlsitedesign.com/ |
|
|
|
|
|
|
Execute a Job or SSIS from a Stored Procedure