Post reply

Transformation Report ?

  • October 24, 2003 at 12:42 am

    #151957

    I want to print a report of the column mapping for a large table-to-table transformation.

    Enterprise manager doesn't seem to be able to print such as report.

    Can I run a query from msdb database ? If so which tables should I examine ?

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

    Mike Duffy

  • 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 6 posts - 1 through 5 (of 5 total)

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