locked
SSIS -Common Scenario with Script Task RRS feed

  • Question

  • Hi Experts ,

    I am workng on SSAS and SSIS for almost an Year .When it comes to SSIS I have never used Script Task
    because I do not have fair knowledge of C#.

    If Some of you could tell some common scenario in SSIS (Task which SSIS developer keep facing in there Professional life )
    where Script Task could be used along with C# code to acheive the Task 

    Link or Step by Step Details would be greately appreciated. 


    This would help me getting better hands on Experience in SSIS & C# to achieve customize task in SSIS .

    Thanks in Advance .
    • Edited by Rihan8585 Tuesday, April 2, 2013 5:39 AM
    Thursday, March 28, 2013 8:51 AM

Answers

  • Hi Rihan,

    It entirely depends on what you want to achieve using script task which cannot be achieved by using exisiting Control flow and dataflow task. Still we have certain things that we may require script task or scipt component.

    1. Send Mail using HTML Format with Links embedded , where you can send mail using Send Mail task , but not in HTML format.

    2. Performing some validations on Text and Excel file whether the number of columns and there order of columns are proper , then you can use script task.

    3. Creating your Own custom component, such as Row number transformation, which will be used to generate Row number .

    Here are some links which will help you in understanding Script task

    http://msdn.microsoft.com/en-us/library/ms141752.aspx

    https://www.simple-talk.com/sql/ssis/adding-the-script-task-to-your-ssis-packages/

    http://microsoft-ssis.blogspot.com/2010/12/how-to-use-variables-in-script-task.html

    Regards

    Naveen

    • Proposed as answer by SSISJoostMVP Thursday, March 28, 2013 11:03 AM
    • Marked as answer by Mike Yin Thursday, April 4, 2013 5:26 AM
    Thursday, March 28, 2013 9:37 AM
  • If you can't achieve something with the standard tasks in the Control Flow then you either use a Custom (/third party) Task or a Script Task. The possibilitiesare (almost) unlimited... (getting file properties, zipping files, adding headers/footers, calling a webservice, etc. etc.)

    The same applies for the Script Component in the Data Flow Task. Most common tasks are: adding rownumber, hashing/encrypting data, regular expressions, webservices, running totals, etc.)


    Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter

    • Marked as answer by Mike Yin Thursday, April 4, 2013 5:26 AM
    Thursday, March 28, 2013 11:26 AM

All replies

  • Hi Rihan,

    It entirely depends on what you want to achieve using script task which cannot be achieved by using exisiting Control flow and dataflow task. Still we have certain things that we may require script task or scipt component.

    1. Send Mail using HTML Format with Links embedded , where you can send mail using Send Mail task , but not in HTML format.

    2. Performing some validations on Text and Excel file whether the number of columns and there order of columns are proper , then you can use script task.

    3. Creating your Own custom component, such as Row number transformation, which will be used to generate Row number .

    Here are some links which will help you in understanding Script task

    http://msdn.microsoft.com/en-us/library/ms141752.aspx

    https://www.simple-talk.com/sql/ssis/adding-the-script-task-to-your-ssis-packages/

    http://microsoft-ssis.blogspot.com/2010/12/how-to-use-variables-in-script-task.html

    Regards

    Naveen

    • Proposed as answer by SSISJoostMVP Thursday, March 28, 2013 11:03 AM
    • Marked as answer by Mike Yin Thursday, April 4, 2013 5:26 AM
    Thursday, March 28, 2013 9:37 AM
  • If you can't achieve something with the standard tasks in the Control Flow then you either use a Custom (/third party) Task or a Script Task. The possibilitiesare (almost) unlimited... (getting file properties, zipping files, adding headers/footers, calling a webservice, etc. etc.)

    The same applies for the Script Component in the Data Flow Task. Most common tasks are: adding rownumber, hashing/encrypting data, regular expressions, webservices, running totals, etc.)


    Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter

    • Marked as answer by Mike Yin Thursday, April 4, 2013 5:26 AM
    Thursday, March 28, 2013 11:26 AM