Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Get the Column information(ole db source and ole db destination) from DTSX (SSIS package) file using C# Expand / Collapse
Author
Message
Posted Thursday, May 23, 2013 6:07 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, November 19, 2013 12:05 AM
Points: 10, Visits: 81
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
Post #1455968
Posted Thursday, May 23, 2013 5:00 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Saturday, August 23, 2014 8:34 AM
Points: 7,097, Visits: 12,601
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
Post #1456245
Posted Friday, May 24, 2013 1:15 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, November 19, 2013 12:05 AM
Points: 10, Visits: 81
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
Post #1456309
Posted Friday, May 24, 2013 4:26 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Saturday, August 23, 2014 8:34 AM
Points: 7,097, Visits: 12,601
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
Post #1456372
Posted Friday, May 24, 2013 6:40 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, November 19, 2013 12:05 AM
Points: 10, Visits: 81
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
Post #1456452
Posted Friday, May 24, 2013 6:54 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Saturday, August 23, 2014 8:34 AM
Points: 7,097, Visits: 12,601
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
Post #1456463
Posted Monday, May 27, 2013 3:48 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, November 19, 2013 12:05 AM
Points: 10, Visits: 81
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
Post #1457025
Posted Monday, May 27, 2013 7:27 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Saturday, August 23, 2014 8:34 AM
Points: 7,097, Visits: 12,601
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
Post #1457103
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse