Dear all,
How organizated the SSIS information in Sql25k is? We've got all the
information regarding dts relationally. Tasks, steps, connections and even
global variables are perfectly stored inside tables (using IDENTITY field we
can to identify any DTS and its features, searchinb by name, databases used
or Transact Sql snippets). It's very useful when you have more than 600 dts
or they're vital for your day-to-day basis due to for the lack of performance
and further details of the original tables (sysdtspackages). But how works
Sql25k with SSIS??
Thanks for any input,
--
Please post DDL, DCL and DML statements as well as any error message in
order to understand better your request. It''s hard to provide information
without seeing the code. location: Alicante (ES)

Hello Enric,

DTS package composition info is not stored inside of any SQL Server tables.
What about when you save to SSF. SQL Server is never involved.

You can access both pieces of info using the respective objent models or
in SSIS you could use XQuery to read the XML (that is after all what an SSIS
package is)


Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com