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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-02-10 : 19:30:31
|
| dan writes "I'm trying to find a direct method of extracting all T-SQL statements from a DTS package and saving this in a flat text file.I need to document the T-SQL statements in all the tasks of several large DTS packages in SS2k. The customer doesn't want to have to open the package in SS2k, but instead wants to inspect the T-SQL statements in text files.I've looked into the different SYSDTS<> tables in MSDB and can't find where the actual SQL statement for the tasks are stored. 1. As a rule we are saving all DTS packages are "storage files."2. I have also saved the packages within SQL Server,3. Finally, I tried saving the package to the Metadata Repository.I've looked into writing ActiveX scripts to do the following:- open each step- select the properties- output to a flat fileHas anyone done something similar?Help appreciated.Regards, Dan" |
|
|
|
|
|
DTS sysdts tables and ActiveX