November 24, 2011 at 11:49 pm
Comments posted to this topic are about the item A VB.NET toolkit for writing SSIS Script Tasks
November 25, 2011 at 1:02 am
🙂 Thanks - the article was just what I (DBA struggling to write VB scripts in SSIS) needed
November 25, 2011 at 1:45 am
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.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 25, 2011 at 2:45 pm
I discovered an omission in lesson 10, but contacted the editors and got it fixed, so I am removing my correction from here.
November 26, 2011 at 1:03 pm
Excellent !!!!!!!!!!!
November 27, 2011 at 5:18 am
Very informative & Helpful thanks...!!!
November 29, 2011 at 7:35 am
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?
November 29, 2011 at 8:00 am
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! 😛
November 29, 2011 at 8:05 am
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. 😎
December 13, 2011 at 4:52 pm
Fantastic article. Easily makes the top 10 list for me.
July 25, 2012 at 3:22 am
I have a query regd SSIS, Please explain how to invoke Crystal Reports report using SSIS Script Task ? Also is it possible to directly export the report to PDF using Script task. I am using the SSIS 2005 version where only VB.net is available for scripting. Thanks in advance...:)
July 25, 2012 at 7:51 am
Without even know what version or product of Crystal reports you are using you most likely will need to checkt he Crystal Reports web site or knowledge base on how to automate reporting tasks and execution using VB.Net script commands.
October 25, 2012 at 4:52 pm
I just stumbled on this and it is exactly what I was looking for. Thanks for taking the time to put it together!
August 20, 2013 at 12:31 pm
I'm trying this out and am finding that the output box displays while the following the input box only shows as icon in the taskbar. Have been unable to determine how to fix this. I have to click on the icon in the taskbar in order to get it to work. Am using windows 7 sp1.
I appreciate the info and will go through the rest of the example, but would appreciate some input into how to resolve that particular problem. Thanks.
August 20, 2013 at 12:32 pm
to clarify: input box shows up -- output box shows as icon in taskbar, which I have to click in order to show
Viewing 15 posts - 1 through 15 (of 27 total)
You must be logged in to reply to this topic. Login to reply