Adding Tasks Programmatically

Question

Adding Tasks Programmatically

saktiranjan

SSC Enthusiast

Points: 172
More actions
November 30, 2007 at 5:25 am

#184476

How can I add Execute SQL Task in the ForEach Loop container through C# code programmatically... Tried a lot with various option, but failed. Since I am new to C# coding, probably I am missing something...Need quick help.
- Sakti

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Powichrowski Marek Hall of Fame Points: 3483 More actions · Answer 1

Please try to explain what you want to do. Are you want to write C# application which executes SSIS packages or anything else?.

saktiranjan SSC Enthusiast Points: 172 More actions · Answer 2

I am trying to develop a package through C# code instead of SSIS designer. By this, the package will be automatically created in a file location and gets executed. So whatever tasks we are using in designer & developing package by dragging & dropping those tasks, I am doing it through C# code where I create all objects and develop. So ultimately when C# code runs, it creates the package and if you open the package, you can see the similarity as developed in designer. I am facing problem while creating Execute SQL task in ForEach Loop container. I hope, you can understand much better now.:)

Powichrowski Marek Hall of Fame Points: 3483 More actions · Answer 3

OK, so what is your problem when creating Execute SQL task using ForEach container under SSIS?

kavita agarwal SSC Enthusiast Points: 154 More actions · Answer 4

Can you give me steps you are following to create package using c# code.I also need to create package dynamically instead of SSIS designer.

Please send me some good link also to read about creating SSIS package dynamically.

Thanks

Bob Pinella SSCommitted Points: 1737 More actions · Answer 5

The following links provide good tutorials for creating an SSIS package programmatically using VB or C#:

To call an existing package:

http://www.codeproject.com/KB/database/CallSSISFromCSharp.aspx

To create a new package from scratch, as well as add tasks programmatically:

http://msdn.microsoft.com/en-us/library/ms135946.aspx

http://msdn.microsoft.com/en-us/library/ms135956.aspx

Bob Pinella

Adding Tasks Programmatically

Cookies on SQLServerCentral