• kwoznica (3/30/2011)


    You mention C# as a scripting tool in conjunction with SSIS. How important is it to know C# for SSIS and what shortcomings do you face without it?

    Is it difficult to take queries I have successfully run and transport them into an ssis package to be run as a job.

    Hi kwoznica,

    You have the choice of C# or VB for scripting in SSIS 2008 and 2008 R2. It's not mandatory to know how to script to write SSIS packages, but knowing scripting adds another tool to your toolbelt for building SSIS (and other) solutions. I recommend you learn as much as you can.

    You can use the Execute SQL Task to run queries in SSIS. Most developers mature as they work with a language or platform - their coding style evolves. Many SSIS developers start learning SSIS by building packages using the Import and Export Data Wizard. This wizard actually creates an SSIS package in RAM and then executes it. You can save the package and open it for editing or re-execute it later.

    Other SSIS developers begin by using only Execute SQL Tasks for T-SQL operations. They use the SSIS Control Flow as a "workflow engine" (it's an excellent workflow engine!) and learn the Data Flow later.

    :{> Andy

    Andy Leonard, Chief Data Engineer, Enterprise Data & Analytics