December 12, 2011 at 12:05 am
Comments posted to this topic are about the item A C#.NET toolkit for writing SSIS Script Tasks
December 12, 2011 at 5:30 am
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...
December 12, 2011 at 6:50 am
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.
December 12, 2011 at 10:26 am
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.
December 13, 2011 at 12:18 am
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.
December 13, 2011 at 1:34 am
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
December 13, 2011 at 2:33 am
"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?
December 13, 2011 at 6:38 am
How do you do it?
December 14, 2011 at 9:29 am
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.
December 14, 2011 at 10:31 am
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?
December 15, 2011 at 8:59 am
I am not sure what you mean by "consume and re-output a data flow."
If I can figure out what you are talking about I will probably write about it.
Thanks!
December 27, 2011 at 1:34 am
Hi Stan, thanks for this. Quite a nice introduction.
This is maybe a bit late in the discussion, but I think what "Old Hand" means by "consume and re-output" a data flow is where a C# script task sits in the middle of a set of task processing a data flow and where it takes in a stream coming from a previous task and outputs data in such a way that it can be taken in by a following task.
That would interest me as well.
Gerard
April 25, 2012 at 12:48 pm
Excellent post! Thank you for taking the time.
September 12, 2014 at 1:20 pm
Stan, thank you for this excellent tutorial. I knew a lot of it already but wish I had read this before I started adding variables to script task in SSIS, took my awhile to realize that the starting value never changes in the variables window only in memory.
In Lesson 5 you wrote ' (Add using System.Collections; to the namespace listing.) '. For Lesson 6 could you add '(Add using System.IO; to the namespace listing.)'? That could be confusing to a total newbie (me a year ago :-)).
March 6, 2016 at 11:02 am
Many thanks Stan for posting this.
CodeMinkey
Viewing 15 posts - 1 through 15 (of 18 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy