SSIS and C# - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

SSIS and Import/Export (2008)

SSIS and C#

Author

Topic

nino.dago
Starting Member

2 Posts

Posted - 2011-11-10 : 08:19:44

Hello,

is it possible to embed C# code in a SSIS package?
Moreover, is it possible to make following tasks?
- to call custom stored procedures inside a SSIS project
- to use a specified table like source of parameters for some stored procedures
- to send email to an address recorded in a database table

Thanks in advance for replies

Bye
Nino

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-11-10 : 09:49:03

sounds like interview questions!! Anyways:-
its possible to use C# code if you add script task inside SSIS
you can call custom stored procedures also through execute sql task
you can do this by populating an object variable with records of table and then iterating over it using for each loop and executing procedure inside it
you can use send mail task for that. you can use a variable to hold the address and use execute sql task to populate the variable.

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

vikashkumar.singh
Starting Member

1 Post

Posted - 2011-11-11 : 07:05:45

It is possible to embed C# or VB.NET code in SSIS package. All of the task you have listed out is possible with the C# code. The only thing you need to consider is that C# code can be used with either Script Task or with Script Component.

__________________________________
Vikash Kumar Singh
www.singhvikash.in

_____________________
Vikash Kumar Singh
www.singhvikash.in

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources