<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Article Discussions
»
Article Discussions by Author
»
Discuss content posted by Stan Kulp
»
A VB.NET toolkit for writing SSIS Script...
13 posts, Page 1 of 2
1
2
»»
A VB.NET toolkit for writing SSIS Script Tasks
Rate Topic
Display Mode
Topic Options
Author
Message
Stan Kulp-439977
Stan Kulp-439977
Posted Thursday, November 24, 2011 11:49 PM
SSC Journeyman
Group: General Forum Members
Last Login: Today @ 8:24 AM
Points: 79,
Visits: 601
Comments posted to this topic are about the item
A VB.NET toolkit for writing SSIS Script Tasks
Post #1211808
Robert Stephenson
Robert Stephenson
Posted Friday, November 25, 2011 1:02 AM
Forum Newbie
Group: General Forum Members
Last Login: Friday, April 13, 2012 3:37 AM
Points: 5,
Visits: 195
Thanks - the article was just what I (DBA struggling to write VB scripts in SSIS) needed
Post #1211829
Koen Verbeeck
Koen Verbeeck
Posted Friday, November 25, 2011 1:45 AM
SSCrazy Eights
Group: General Forum Members
Last Login: Today @ 2:11 AM
Points: 9,378,
Visits: 6,473
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
Stan Kulp-439977
Stan Kulp-439977
Posted Friday, November 25, 2011 2:45 PM
SSC Journeyman
Group: General Forum Members
Last Login: Today @ 8:24 AM
Points: 79,
Visits: 601
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
aditya-457589
aditya-457589
Posted Saturday, November 26, 2011 1:03 PM
Valued Member
Group: General Forum Members
Last Login: Monday, September 03, 2012 10:02 AM
Points: 62,
Visits: 199
Excellent !!!!!!!!!!!
Post #1212144
nithinkotian 88970
nithinkotian 88970
Posted Sunday, November 27, 2011 5:18 AM
Forum Newbie
Group: General Forum Members
Last Login: Wednesday, April 04, 2012 1:40 AM
Points: 1,
Visits: 8
Very informative & Helpful thanks...!!!
Post #1212189
SanDroid
SanDroid
Posted Tuesday, November 29, 2011 7:35 AM
Ten Centuries
Group: General Forum Members
Last Login: Thursday, January 31, 2013 8:01 AM
Points: 1,232,
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
Stan Kulp-439977
Stan Kulp-439977
Posted Tuesday, November 29, 2011 8:00 AM
SSC Journeyman
Group: General Forum Members
Last Login: Today @ 8:24 AM
Points: 79,
Visits: 601
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
SanDroid
SanDroid
Posted Tuesday, November 29, 2011 8:05 AM
Ten Centuries
Group: General Forum Members
Last Login: Thursday, January 31, 2013 8:01 AM
Points: 1,232,
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
TEwing
TEwing
Posted Tuesday, December 13, 2011 4:52 PM
Forum Newbie
Group: General Forum Members
Last Login: Tuesday, May 07, 2013 9:08 AM
Points: 5,
Visits: 53
Fantastic article. Easily makes the top 10 list for me.
Post #1221268
« Prev Topic
|
Next Topic »
13 posts, Page 1 of 2
1
2
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
