Writing .NET code to programatically build SSIS packages?

June 12, 2013 5:08 PM

I'm looking into a project where I need to create an SSIS package in a programmatic way. The Microsoft articles on this topic are fairly arcane. I was hoping that there was someone who had built a wrapper or library to be able to create and manipulate these packages more easily through .NET code, but haven't found any. Suggestions welcome, though the criteria of SSIs and .NET are not negotiable.
posted by DWRoelands to Computers & Internet (2 answers total)

What exactly is confusing about these articles? They seem straightforward enough. See here and adding tasks here.

You can always use a regular database migration utility, take the generated SQL, wrap it in an SSIS package/task and that would fulfill your SSIS criteria while using something less enterprisey.
posted by geoff. at 5:33 PM on June 12, 2013

Have you looked at the BIML package generator in BIDSHelper? BimlScript might be what you need. Worst case, if you need to generate and compile BIMLs into DTSX on the fly, the source code is there so you can add the source code from the BIML compiler to your project and then use it from there.
posted by crazycanuck at 8:14 PM on June 12, 2013