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 |
|
kond.mohan
Posting Yak Master
213 Posts |
 Posted - 2012-02-27 : 04:43:45
|
| Hi,i have saved my ssis packages in d:\abcd\new folder nearly 50 packges are stored in this folder i want to execute this packges through SQL server STORED PROCEDURE how to pass the this folder location all these things to stored procedure.can any body know how to execute packges throug stored procedure. |
|
|
sg2255551
Constraint Violating Yak Guru
274 Posts |
Posted - 2012-02-27 : 05:03:02
|
| First you would have to enable xp_cmdshellCreate a proc then use EXEC xp_cmdshell 'dtexec /f "C:\UpsertData.dtsx"'Hope this helps |
 |
|
|
vijays3
Constraint Violating Yak Guru
354 Posts |
Posted - 2012-02-27 : 15:36:17
|
| check this out..http://www.codeproject.com/Articles/27156/How-to-Call-SSIS-Package-from-the-Stored-Procedure |
|
|
|
|
|
|
ssis pkg execution