Microsoft SQL Server 2000 DTS as text

Question

I've to document a bunch of SQL Server 2000 DTS, is it possible to export the DTS definition in text format?

Thanks.

Han

Answer 1

I seem to recall 'save to visual basic', and have done so once. Will that be useful for you?

See also: http://msdn.microsoft.com/en-us/library/cc917688.aspx

Answer 2

I've found an interesting previus answer by Ed Harper in Get DTS Step Description from TSQL?. The solution is to use an activex script to extract DTS relevant information in text format.

The script is provided here thanks to Nigel Rivett.

Han