A VB.NET toolkit for writing SSIS Script Tasks

  • Stan Kulp-439977

    SSCrazy Eights

    Points: 9942

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

  • Robert Stephenson

    SSC Veteran

    Points: 203

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

  • Koen Verbeeck

    SSC Guru

    Points: 258890

    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

  • Stan Kulp-439977

    SSCrazy Eights

    Points: 9942

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

  • aditya-457589

    SSC Enthusiast

    Points: 156

    Excellent !!!!!!!!!!!

  • nithinkotian 88970

    SSC Journeyman

    Points: 79

    Very informative & Helpful thanks...!!!

  • SanDroid

    SSChampion

    Points: 10068

    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?

  • Stan Kulp-439977

    SSCrazy Eights

    Points: 9942

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

  • SanDroid

    SSChampion

    Points: 10068

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

  • TEwing

    SSC Enthusiast

    Points: 132

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

  • VSSGeorge

    SSCertifiable

    Points: 7922

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

  • SanDroid

    SSChampion

    Points: 10068

    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.

  • George M Parker

    SSCertifiable

    Points: 5382

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

  • jjames 36349

    SSC Enthusiast

    Points: 146

    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.

  • jjames 36349

    SSC Enthusiast

    Points: 146

    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