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
Generating packages using C#
wingsalltheway19
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.
LenardG
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
---