by robotix1986
22. June 2009 20:43
Hi g33ks,
The SSIS object model gives us the flexibility of dynamically creating SSIS packages and running them. One major boon with this is that instead of doing column mapping of DFTs at design time, we can do this at runtime and have the mapping information in the metadata.
Today instead of posting some sample code for some basic stuff in creating SSIS packages, I thought that it would make more sense to just post some links which have sample code for various kinds of basic tasks in SSIS. So here goes.
Adding connections - http://msdn.microsoft.com/en-us/library/ms136093.aspx
Variables - http://msdn.microsoft.com/en-us/library/ms136082.aspx
Adding a Data Flow Task - http://msdn.microsoft.com/en-us/library/ms135997.aspx
Adding Data Flow Components - http://msdn.microsoft.com/en-us/library/ms135932.aspx
Connecting Data Flow Components - http://msdn.microsoft.com/en-us/library/ms136086.aspx
ADO.NET Source - http://blogs.msdn.com/mattm/archive/2008/12/30/api-sample-ado-net-source.aspx
OLEDB Source & Destination - http://blogs.msdn.com/mattm/archive/2008/12/30/api-sample-oledb-source-and-oledb-destination.aspx
Saving a Package - http://msdn.microsoft.com/en-us/library/ms403347.aspx
More elaborate samples to come soon. Till then, Adeus.
Regards,
AlD