Post reply

Listing Source & Target fields in transformation

  • October 29, 2002 at 10:44 pm

    #159057

    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

    #439773

    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 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply