InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 05:09:29 GMT20http://www.sqlservercentral.com/Forums/Topic1220012-2674-1.aspxExcellent post! Thank you for taking the time.Wed, 25 Apr 2012 12:48:18 GMTRob Sondershttp://www.sqlservercentral.com/Forums/Topic1220012-2674-1.aspxHi 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.GerardTue, 27 Dec 2011 01:34:40 GMTGerard van de Venhttp://www.sqlservercentral.com/Forums/Topic1220012-2674-1.aspxI 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!Thu, 15 Dec 2011 08:59:38 GMTStan Kulp-439977http://www.sqlservercentral.com/Forums/Topic1220012-2674-1.aspxThis 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?Wed, 14 Dec 2011 10:31:23 GMTAmy.Ghttp://www.sqlservercentral.com/Forums/Topic1220012-2674-1.aspxOne 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.Wed, 14 Dec 2011 09:29:34 GMTricharddhttp://www.sqlservercentral.com/Forums/Topic1220012-2674-1.aspxHow do you do it?Tue, 13 Dec 2011 06:38:12 GMTStan Kulp-439977http://www.sqlservercentral.com/Forums/Topic1220012-2674-1.aspx"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?Tue, 13 Dec 2011 02:33:18 GMTmalcolm.grayhttp://www.sqlservercentral.com/Forums/Topic1220012-2674-1.aspxA 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 understandTue, 13 Dec 2011 01:34:12 GMTtimwamhttp://www.sqlservercentral.com/Forums/Topic1220012-2674-1.aspxThis 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.Tue, 13 Dec 2011 00:18:37 GMTmishalubahttp://www.sqlservercentral.com/Forums/Topic1220012-2674-1.aspxGreat 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.Mon, 12 Dec 2011 10:26:14 GMTken.otoolehttp://www.sqlservercentral.com/Forums/Topic1220012-2674-1.aspxI 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.Mon, 12 Dec 2011 06:50:53 GMTStan Kulp-439977http://www.sqlservercentral.com/Forums/Topic1220012-2674-1.aspxLesson 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 [url=http://msdn.microsoft.com/en-us/library/microsoft.sqlserver.dts.pipeline.scriptcomponent.log.aspx]Log[/url] method, or firing an event to be handled by the Package, with [url=http://msdn.microsoft.com/en-us/library/microsoft.sqlserver.dts.pipeline.wrapper.idtscomponentmetadata100.fireinformation.aspx]FireInformation[/url].Otherwise, that's a good introduction to script tasks...Mon, 12 Dec 2011 05:30:53 GMTjimbobmcgeehttp://www.sqlservercentral.com/Forums/Topic1220012-2674-1.aspxComments posted to this topic are about the item [B]<A HREF="/articles/Integration+Services+(SSIS)/76439/">A C#.NET toolkit for writing SSIS Script Tasks </A>[/B]Mon, 12 Dec 2011 00:05:48 GMTStan Kulp-439977