SSIS Team Blog

Helpful information and examples on how to use SQL Server Integration Services.

Samples for creating SSIS packages programmatically

Samples for creating SSIS packages programmatically

  • Comments 6

This is an index post for the series of posts with examples on how to create packages programmatically. Creating and adding tasks to a control flow is pretty straightforward, but programmatically adding data flow components can be tricky due to the interaction with the native COM APIs. Each post will provide a simple scenario for using each component.

All samples are done using SQL Server 2008, but will also work with 2005 with minor code modifications.

I’ll continue to update this post as more samples are added. Please post in the comments if there are specific data flow components you’d like to see.





For an end to end solution, check out the Package Generation sample available on codeplex.

Other resources

  • Hi,

    I need to develop Aggregate component programmatically. It would great If you post the code for Aggregate.



  • Hi

    I need to develop Data Conversion Component with data source as sqlserver and destination as Excel Sheet ,it will be helpful if u paste code for the same

  • Hi can anyone tell me the hierarchy how we should create the package when we does programmatically and why to do in that order? Like Package --> ControlFlow --> DataFlow and so on.

  • Please give and example for developing script component programmatically.

  • Hi,

    Have a look at the following post:

  • Hi

    I would like to add CDC Control Task programmatically  

    Can you point me in the right direction

    best regards


Page 1 of 1 (6 items)
Leave a Comment
  • Please add 6 and 5 and type the answer here:
  • Post