DTS Transformations - Print /list?

[PaulSc]

Hello,

Can anyone suggest a way to print out a quite complicated data transformation routine from a SQL DTS ??

the DTS window wont expand and with transformations criss crossing all over the file layout (new file to legacy format) screen dumps dont show the links correctly.....

field1--------field1
field2--\
.. \ /--field27
.. \/ ..
field99--/ \--field99 etc etc

or is there a way to print out a report etc

i.e

field 1 to field1
field 2 to field99
field99 to field27

Thanks in advance...

 

[PaulSc]

Sorry should say that this is in SQL 2000...

 

[fuzzyocelot]

I don't know if it will help or not, but you could try saving it as a Visual Basic file and then open it in Visual Basic. It's not really a report but it shows what it's doing. It could give you a starting point. Just a thought!