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 |
|
sreeni12345
Starting Member
14 Posts |
 Posted - 2014-06-12 : 09:14:52
|
| I have a .dtsx file . Now my requirement is to know which are the stored procedures involved in the file and also if any tables involved in it. Please suggest me an way around for this |
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2014-06-12 : 10:36:25
|
| open the file in BIDS and look at the Execute SQL tasks and the various tasks in the dataflow |
 |
|
|
sreeni12345
Starting Member
14 Posts |
Posted - 2014-06-13 : 01:54:59
|
| But i dont have option of BIDS in my system. So can u suggest me any tools or renaming the extensions of the file and working out |
|
|
|
waterduck
Aged Yak Warrior
982 Posts |
Posted - 2014-06-13 : 04:38:48
|
| not quite sure this software can help you.http://www.ssisdocumenter.com/ssisdocumenter.aspx |
|
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2014-06-13 : 07:33:11
|
| a dtsx is simply an xml file. I think you can read it and figure out the details. |
|
|
|
|
|
|
To know the strd procs and tbls in .dtsx