The dts are stored in the msdb database in the tables sysdtspackages,
sysdtssteplog, sysdtspackagelog, etc...

Somebody knows how obtaining the querys o commands (text) contained in each
step of the dts?

This is becouse I need to know what tables are used for what dts,
facilitating my task of modification of dts whenever a table be modified


Thanks for your help,


Adal

Adatap wrote:
You cannot query or modify the internals of a DTS package through
tables. The package data is in an image column, but it is COM structured
storage, so you would need to use the object model to get anything out
of it. That is exactly what the LoadFromSQLServer method will do for you
on Package object.

--
Darren
http://www.sqldts.com
http://www.sqlis.com