A VB.NET toolkit for writing SSIS Script Tasks

  • Comments posted to this topic are about the item A VB.NET toolkit for writing SSIS Script Tasks

  • 🙂 Thanks - the article was just what I (DBA struggling to write VB scripts in SSIS) needed

  • 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

  • I discovered an omission in lesson 10, but contacted the editors and got it fixed, so I am removing my correction from here.

  • Excellent !!!!!!!!!!!

  • Very informative & Helpful thanks...!!!

  • 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?

  • 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! 😛

  • 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. 😎

  • Fantastic article. Easily makes the top 10 list for me.

  • 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...:)

  • 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.

  • I just stumbled on this and it is exactly what I was looking for. Thanks for taking the time to put it together!

  • 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.

  • 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 28 total)

You must be logged in to reply to this topic. Login to reply