Post reply

Get the Column information(ole db source and ole db destination) from DTSX (SSIS package) file using C#

  • May 23, 2013 at 6:07 am

    #394838

    HI,

    I have lots of SSIS packages and i have to make the column mapping sheet for the SSIS packages .

    I have tried the reading SSIS (DTSX) file from C# - dot net but i was unable to get the relationship between OLE DB Source and OLE DB Destination (SSIS Package) in Dot net .

    ISSUE :

    Let say i have a dts package and that packages have one ole db source and one ole db destination and in that i am transferring the data from source column to destination column so now i want to make the column mapping file like Ole db source A(source column )----------->ole db destination B(destination column) like this for all the column.

    Please tell me how can i do that using dot net.

    Regards,

    Anshuman Saini

  • May 23, 2013 at 5:00 pm

    #1618060

    What are you using from .NET? Are you trying to read the raw XML or are you using the SSIS Object Model assemblies?

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • May 24, 2013 at 1:15 am

    #1618115

    Hi ,

    I want to read the DTSX file from C# and read all the object from that ole db source and old db destination and how many column we have mapped from source to destination.and if we are using any other task between these two lookup , ole db command etc .so that i can make the column mapping sheet from reading DTSX file.

    Regards,

    Anshuman saini

  • May 24, 2013 at 4:26 am

    #1618161

    It should only require a small amount of code to do that using the SSIS Object Model:

    Integration Services Programming

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • May 24, 2013 at 6:40 am

    #1618233

    Thanks a lot for your reply , but i have tried this url but i didn't get suitable information.

    Can you please tell me which one you are telling

  • May 24, 2013 at 6:54 am

    #1618243

    Here are some code samples to help you get started.

    http://www.sqlis.com/sqlis/post/Exploring-packages-in-code.aspx

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • May 27, 2013 at 3:48 am

    #1618723

    Thanks for reply 🙂

    i have already written the code to get the executable task from SSIS using C# but i need to access the column of ole db source and ole db destination with relation.

    Please help if you have something regarding this

  • May 27, 2013 at 7:27 am

    #1618787

    Follow the first link I posted earlier and follow Data Flow Properties Reference to see some links showing how to read the properties of various Data Flow Components.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

Viewing 8 posts - 1 through 7 (of 7 total)

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