Post reply

Transformation Report ?

  • October 24, 2003 at 7:14 am

    #479454

    The column names are stored in the syscolumns table in the Master Database.

    But it is safer to use sp_columns 'tablename' to view the column names in a table.

    If it aint broke don't fix it!


    Andy.

  • October 25, 2003 at 6:38 pm

    #479594

    No that's not what I asked for.

    I need a report of the COLUMN MAPPINGS in a DTS transformation, not all the columns in a table.

    eg

    Source Col Destination Col

    =========== ===============

    Column 1 ---> Column Q

    Column 2 ---> Column H

    Column 3 ---> Column W

  • October 28, 2003 at 11:58 am

    #479956

    Couldn't you open up the transformation script and either save the script as a file, or copy the contents of the script into Word, etc.

  • October 28, 2003 at 3:10 pm

    #479986

    DTS pacakges are stored as BLOBs in msdb..sysdtspackages. So no T-SQL query going to be able to extract the info you need.

    cocr's suggestion is probably the closest you'll get to an easy solution. Save the package as a VB file and from that you'll be able to extract the info.

    Otherwise you could write a VBScript to trawl through the Datapump task and extract the column mappings from the Transformations collection.

    Hope this helps

    Phill Carter

    --------------------

    Colt 45 - the original point and click interface

    --------------------
    Colt 45 - the original point and click interface

  • October 31, 2003 at 9:40 pm

    #480551

    Thanks for the reply. The VBS file appears to be pure object1 = <column1> and column2 = object1 kind of stuff, so its not a clear mapping and not what I was hoping for.

    Thanks anyway.

Viewing 5 posts - 1 through 6 (of 6 total)

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