Post reply

Generate column Mapping report in Excel from SSIS Package

  • July 14, 2011 at 4:33 am

    #240811

    I need to Create a SSIS Package and generate a column mapping report into excel sheet. For exampl IF Table A Contains following Columns

    A

    B

    C

    D

    E

    and from SSIS package i am putting that data into Three Table Called Table B , Table C and Table D

    and

    Table A's A and B columns are mapped with Table B's G and H columns

    Table A's C and D columns are mapped with Table C's I and J columns

    Table A's A and E columns are mapped with Table D's K and L columns

    Then

    Excel sheet should contains the columns mapping only. Kindly help me out to achieve this.

    Thanks in advance :).

    Thanks,

    Rakesh

  • July 14, 2011 at 4:56 am

    #1352688

    How do you put the data in the tables?

    Do you use a dataflow, an Execute SQL Task, a script task, ... ?

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • July 14, 2011 at 9:18 pm

    #1353165

    I am using Dataflow to Populate the destination tables.

  • July 14, 2011 at 11:47 pm

    #1353197

    Well there isn't anything out of the box to do that for you (yet, in Denali it will be possible).

    So if you really want to generate the metadata, you'll need to crack open the package using C# and look at the object model to retrieve everything. Or parse the XML behind the .dtsx.

    edit: it's possible there are already 3rd party tools out there that can do that for you. Take a look at BIDocumenter.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • July 15, 2011 at 4:31 am

    #1353300

    Thanks for the reply however I am looking if SSIS Packages can provide something like that.

    Thanks & Regards,

    Rakesh

  • July 15, 2011 at 4:42 am

    #1353303

    rakesh.sharma1981 (7/15/2011)

    Thanks for the reply however I am looking if SSIS Packages can provide something like that.

    Thanks & Regards,

    Rakesh

    Out of the box? No.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

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

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