November 20, 2002 at 7:44 am
Anyone know of a way to get specific data regarding DTS packages (i.e. names, tasks, connection utilized, etc.). I know the DTS data is stored in msdb, but didn't know it there was an sp I could run or would I need to create one?
Thanks in advance
November 20, 2002 at 8:18 am
The package data is held in sysdtspackages and the package info is held in an image column, so you can't really query it.
Have a look on www.sqldts.com
Simon Sabin
Co-author of SQL Server 2000 XML Distilled
http://www.amazon.co.uk/exec/obidos/ASIN/1904347088
Simon Sabin
SQL Server MVP
http://sqlblogcasts.com/blogs/simons
November 20, 2002 at 8:38 am
That's what I thought. Thanks anyway.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply