A C#.NET toolkit for writing SSIS Script Tasks

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Stan Kulp » A C#.NET toolkit for writing SSIS Script...

13 posts, Page 1 of 2

1 2 »»

A C#.NET toolkit for writing SSIS Script Tasks

Rate Topic

Display Mode

Topic Options

Author

Message

Stan Kulp-439977

Posted Monday, December 12, 2011 12:05 AM

SSC Journeyman

Group: General Forum Members
Last Login: 2 days ago @ 10:00 AM
Points: 78, Visits: 597

Comments posted to this topic are about the item A C#.NET toolkit for writing SSIS Script Tasks

Post #1220012

jimbobmcgee

Posted Monday, December 12, 2011 5:30 AM

SSC Rookie

Group: General Forum Members
Last Login: Yesterday @ 4:14 AM
Points: 36, Visits: 555

Lesson 17:
Never use MessageBox.Show in the course of your automated ETL process. It blocks operation of the remaining code until a button is pressed. Instead, favour logging to a log provider with the Log method, or firing an event to be handled by the Package, with FireInformation.

Otherwise, that's a good introduction to script tasks...

Post #1220139

Stan Kulp-439977

Posted Monday, December 12, 2011 6:50 AM

SSC Journeyman

Group: General Forum Members
Last Login: 2 days ago @ 10:00 AM
Points: 78, Visits: 597

I was using MessageBox.Show as a development tool to illustrate what the code is doing.

Of course you would not include them in production code.

Post #1220226

ken.otoole

Posted Monday, December 12, 2011 10:26 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, January 22, 2013 9:10 AM
Points: 3, Visits: 107

Great Stuff!! Thanks for posting this Stan.
I'm fairly new to SSIS and have been trying to determine how to gain sufficient C# skills for those occasions when I really need a script task. I think you've solved a large part of my problem and provided a great foundation.

Post #1220378

mishaluba

Posted Tuesday, December 13, 2011 12:18 AM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 5:54 PM
Points: 525, Visits: 617

This is a great summary of the main things one would need to know about scripting as it relates to SSIS. Of course with .NET there are endless possibilities, but this is a great start! Thank you.

Post #1220621

timwam

Posted Tuesday, December 13, 2011 1:34 AM

Old Hand

Group: General Forum Members
Last Login: Friday, May 17, 2013 4:04 AM
Points: 397, Visits: 176

A useful follow-up to this would be some code to consume and re-output a data flow - this would be a verycommon task, and is a little fiddly to understand

Post #1220660

malcolm.gray

Posted Tuesday, December 13, 2011 2:33 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, May 02, 2013 5:49 AM
Points: 1, Visits: 46

"Double-click on the Script Task and select "Microsoft Visual Basic 2008" from the Script Language drop-down list, "
really - is that the best way to get C# code?

Post #1220696

Stan Kulp-439977

Posted Tuesday, December 13, 2011 6:38 AM

SSC Journeyman

Group: General Forum Members
Last Login: 2 days ago @ 10:00 AM
Points: 78, Visits: 597

How do you do it?

Post #1220842

richardd

Posted Wednesday, December 14, 2011 9:29 AM

SSCommitted

Group: General Forum Members
Last Login: Thursday, May 16, 2013 7:26 AM
Points: 1,852, Visits: 484

One small issue - there is no "C#.NET"; it's just called "C#".

VB gained the ".NET" suffix to differentiate it from the pre-.NET versions, but C# was created at the same time as .NET, and so never needed the suffix.

Post #1221813

Amy.G

Posted Wednesday, December 14, 2011 10:31 AM

SSC Journeyman

Group: General Forum Members
Last Login: Friday, May 10, 2013 9:35 AM
Points: 94, Visits: 258

This was really fun to go through. I'm looking for other tutorials on C# to use in SSIS, but am only seeing videos. Anyone know of a good site to walk through?

Post #1221862

« Prev Topic | Next Topic »

13 posts, Page 1 of 2

1 2 »»

Permissions