how to get DTS information? | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

how to get DTS information?

Hi All
if anyone knows how to get the DTS package information, like connection string, password etc, without opening the DTS package in Design screen? the DTS packages stored in SQL Server 2000. thanks in advance for your great assistance. –Long
maybe turn on profiler and see what goes on behind the scenes

No way, with profiler (like eramgarden said) you have some information but not all what you want.
Luis Martin
Moderator
SQL-Server-Performance.com All in Love is Fair
Stevie Wonder
All postings are provided “AS IS” with no warranties for accuracy.
hello Mr newchina
the best way is follow this link.defnetly u will get some useful information.and anyway BOL is the other source. http://www.microsoft.com/technet/prodtechnol/sql/2000/books/c07ppcsq.mspx#E1MAE vinod kumar mallolu
Well said and good reference.
quote:Originally posted by sunsanvin hello Mr newchina
the best way is follow this link.defnetly u will get some useful information.and anyway BOL is the other source. http://www.microsoft.com/technet/prodtechnol/sql/2000/books/c07ppcsq.mspx#E1MAE vinod kumar mallolu

Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing.
thanks for all the good reference. i wished i could get connection info from certain system tables. –Long

]]>