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 |
|
under2811
Constraint Violating Yak Guru
366 Posts |
 Posted - 2010-12-06 : 08:41:19
|
| Hi I need one query which gives me which Stored Procedure is called by which SSIS Package?It is needed for migration record.T.I.A |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2010-12-06 : 08:48:33
|
| If you have the packages stored as files then you can run a script to parse them.It's easier if you have a distinctive name for the SPs.You can use the shell script at the bottom of this to get the rows in the files that contain SP callshttp://www.nigelrivett.net/ShellScript/DosBatchLoopConcatenateFiles.html==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
Chk which SP is called by which Package