Wednesday, March 21, 2012

Generating packages using C#

Hi,

we would like to generate SSIS packages(connections, data flow tasks, etc..) programatically using C#. Is it possible to do so?

At present we are creating packages by dragging and dropping required componets from toolbox and configuring them manually. We have a requirement of creating around 300 packages every week. Manual creation of packages is really a nightmare.

I heard from one of friends that using c# we can create packages. is it true? if so, can we view/edit the packages generated using c# using VS 2005 IDE(if required) ?

Regards,

Gopi

Hi,

there are several namespaces of Microsoft which can be used to generate you packages. But I am afraid that this is not as use-friendly as the GUI features of SSIS.

http://msdn2.microsoft.com/en-us/library/ms183036(SQL.90).aspx

HTH, jens Suessmeyer.

http://www.sqlserver2005.de

|||

Try Books Online, Building and Saving Packages Programmatically, http://msdn2.microsoft.com/en-us/library/ms136076(SQL.90).aspx

Once saved, regardless of the method used to generate it, C#, VS/BIDS IDE, Wizard, you can still open it in any SSIS tool.

No comments:

Post a Comment