Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 123»»»

A VB.NET toolkit for writing SSIS Script Tasks Expand / Collapse
Author
Message
Posted Thursday, November 24, 2011 11:49 PM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, December 17, 2014 2:02 PM
Points: 130, Visits: 946
Comments posted to this topic are about the item A VB.NET toolkit for writing SSIS Script Tasks
Post #1211808
Posted Friday, November 25, 2011 1:02 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, August 20, 2013 1:19 PM
Points: 5, Visits: 199
Thanks - the article was just what I (DBA struggling to write VB scripts in SSIS) needed


Post #1211829
Posted Friday, November 25, 2011 1:45 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Thursday, December 18, 2014 12:52 PM
Points: 13,636, Visits: 11,509
Nice overview, thanks.

I'm trying to convince some coworkers that moving all the files in a directory is much easier in a .NET script task (4-5 lines of code) than using the For Each Loop with the File System Task.




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1211850
Posted Friday, November 25, 2011 2:45 PM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, December 17, 2014 2:02 PM
Points: 130, Visits: 946
I discovered an omission in lesson 10, but contacted the editors and got it fixed, so I am removing my correction from here.
Post #1212068
Posted Saturday, November 26, 2011 1:03 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, September 9, 2014 3:23 AM
Points: 62, Visits: 200
Excellent !!!!!!!!!!!
Post #1212144
Posted Sunday, November 27, 2011 5:18 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, April 4, 2012 1:40 AM
Points: 1, Visits: 8
Very informative & Helpful thanks...!!!
Post #1212189
Posted Tuesday, November 29, 2011 7:35 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, January 31, 2013 8:01 AM
Points: 1,228, Visits: 1,046
Great article and nice set of Script example code.
I have a question about it though.
We do a lot of similar ETL updates to row records during import by using SSIS DATA FLOW task and the "Script Transformation" component in the Data Flow task. This runs fast in debug mode and very fast on the server.

Is there a reason you do it this way instead of a Script Transformation in a Data Flow task object?
Post #1213252
Posted Tuesday, November 29, 2011 8:00 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, December 17, 2014 2:02 PM
Points: 130, Visits: 946
My goal was to create an introduction to writing functional script tasks while keeping it as simple as possible. Using a script task as a data transformation component in a data flow task is the next logical step in the learning process, but it is the next step. It is also a future article I intend to write. Unless you write it first!
Post #1213269
Posted Tuesday, November 29, 2011 8:05 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, January 31, 2013 8:01 AM
Points: 1,228, Visits: 1,046
Stan Kulp-439977 (11/29/2011)
My goal was to create an introduction to writing functional script tasks while keeping it as simple as possible. Using a script task as a data transformation component in a data flow task is the next logical step in the learning process, but it is the next step. It is also a future article I intend to write. Unless you write it first!


Thanks for the quick and honest response. The information in the article about using your Script Task instead of FOR or FOR EACH Loop tasks to update row records confused me. Look forward to the next article.
Post #1213274
Posted Tuesday, December 13, 2011 4:52 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, October 28, 2014 2:35 PM
Points: 14, Visits: 57
Fantastic article. Easily makes the top 10 list for me.
Post #1221268
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse