December 13, 2004 at 5:12 am
In order to automate documentation I've managed to write some scripts that list pairs of source and destination tables. I now want to get down to the column level. Although I can see examples of writing these and I think I need to read the transformations collections I can't see how to read this detail.
Can anyone give me some pointers on how I can read this part of the package ?
December 13, 2004 at 7:42 am
Can you please let me know what information you are looking into.
If you need the column information for a table you can obtain the same from the SYSCOLUMNS system table.
You can find the script for the same at the link mentioned below:
http://www.sqlservercentral.com/scripts/contributions/1311.asp
Please do let me know if you require any further information
December 13, 2004 at 7:51 am
I'm after a list of column pairs in each tranformation of the DTS package.
e.g.
Transformation_1
Col1 , ColA
Col2, ColC
Col3, ColD
etc..
I know the input and output tables but can't find out how to read this lower level of detail.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply