October 29, 2002 at 10:44 pm
I need to list all the fields in the source and target columns for a particular DTS package transformation task.
I have been able to find the step in which the transformation will take place, but cannot find any information on how to actually list the fields in the task. Ideally I would like to list them and report on the references between them ie:
Source Field1 maps to Target Field 10 & 12.
This way, I could document my DTS references using the information retrieved in this way. It should also be possible to actually print out the ActiveX script for a particular mapping.
I would appreciate any help I can get.
Graham
October 30, 2002 at 12:35 am
Save your package as a Visual Basic File and open it and look at the code that was generated. This will give you the syntax you can use in an activex script.
hth,
Michael
Michael Weiss
Michael Weiss
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy