July 16, 2012 at 11:38 pm
How is scripting done in SSIS ? Should I know .net to do the scripting?
Any useful links on scripting?
July 16, 2012 at 11:47 pm
Dear George,
Scripting can be done using either Script Task or ActiveX Script Task;
Script task has the power to write code in VB.NET or C#.NET; so you get more object model classes; more easy to use APIs etc.
As a quick search, I found these two links for Script Task tutorial:
http://www.sqlservercentral.com/articles/Integration+Services+%28SSIS%29/68863/
http://sqlserverpedia.com/blog/sql-server-2008/demystifying-the-ssis-script-component-part-1/
Please note that it is better to have some basic knowledge of either of these .NET languages to better utilize it.
July 17, 2012 at 8:19 am
Yes you need to know or learn some .NET to script in SSIS. You should avoid the ActiveX Script Task because it is basically added to support migration from DTS.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
July 17, 2012 at 1:36 pm
In SSIS 2005 you could use VB.NET. As of SSIS 2008 you have the option to use VB.NET or C#.
Here are examples from Microsoft that show what they had in mind when they exposed scripting in SSIS. Script Tasks are used in the Control Flow and Event Handler design areas. Script Components are used in the Data Flow design area.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 24, 2012 at 4:41 am
Thank You all.. for the replies..!!
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply