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 |
|
sqlfresher2k7
Aged Yak Warrior
623 Posts |
 Posted - 2012-05-30 : 09:14:44
|
| How to find objects like tables,sp,views etc used in the ssis package with SQL query. |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2012-05-30 : 09:19:20
|
| Not so easy. They can be changed at run time so nothing you do will be guaranteed.In the past I've done things which search the xml files using dos command files to see what they were saved as - easier if you hold ssis pakcages in files.==========================================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. |
 |
|
|
|
|
|
Query