locked
what is the difference between data flow task and execute sql task in ssis RRS feed

  • Question

  • what is the difference between data flow task and execute sql task in ssis and which is better?
    Tuesday, March 14, 2017 2:25 PM

Answers

  • Hello,

    Use Execute Task to work with databases, query and update them, run stored procedures.

    If you need to transform data, have control of each record, implement error handling and logging then use Data Flow transformation. Data Flow may take data from database, transform it, and put it on the data back.



    Hope this helps.



    Regards,

    Alberto Morillo
    SQLCoffee.com


    Tuesday, March 14, 2017 2:38 PM
  • Hi,

    Data flow is used to copy data from one source to another (like exporting SQL table to CSV or importing data from Oracle into SQL)

    Execute SQL task is used to run SQL code (typically a stored procedure)


    Tuesday, March 14, 2017 2:41 PM
  • what is the difference between data flow task and execute sql task in ssis and which is better?

    You can't compare them.

    Data Flow Task is a container for other tasks.

    The Execute SQL Task is a narrow purpose task that speaks for itself.

    Also "better" is always depends pertaining to everything and does not work always, one should not stuck to one thing or another, but adopt to circumstances.


    Arthur

    MyBlog


    Twitter

    • Proposed as answer by Albert_ Zhang Monday, March 20, 2017 4:24 PM
    • Marked as answer by Vinod Ulava Thursday, November 21, 2019 7:51 AM
    Tuesday, March 14, 2017 2:44 PM
  • Data flow task :-

    Most of ETL operations are performed in DFT. As the name suggest, this task is used to transfer the data from source to destination. While transferring the data, operations like merge, merge join, data conversion etc. can be performed. This whole process involves Extracting the data from source, Transformation of data in the form expected in destination and then Load the data into destination which is nothing but ETL.

    Execute sql task:-

     show different types of usage for the task:

    • Returning a single value from a SQL query with two input parameters.
    • Returning a rowset from a SQL query.
    • Executing a stored procedure and retrieveing a rowset, a return value, an output parameter value and passing in an input parameter.
    • Passing in the SQL Statement from a variable.
    • Passing in the SQL Statement from a file.


    Please Mark it as Answered if it answered your question OR mark it as Helpful if it help you to solve your problem.

    • Marked as answer by Vinod Ulava Thursday, November 21, 2019 7:51 AM
    Friday, March 31, 2017 5:38 AM

All replies

  • Hello,

    Use Execute Task to work with databases, query and update them, run stored procedures.

    If you need to transform data, have control of each record, implement error handling and logging then use Data Flow transformation. Data Flow may take data from database, transform it, and put it on the data back.



    Hope this helps.



    Regards,

    Alberto Morillo
    SQLCoffee.com


    Tuesday, March 14, 2017 2:38 PM
  • Hi,

    Data flow is used to copy data from one source to another (like exporting SQL table to CSV or importing data from Oracle into SQL)

    Execute SQL task is used to run SQL code (typically a stored procedure)


    Tuesday, March 14, 2017 2:41 PM
  • what is the difference between data flow task and execute sql task in ssis and which is better?

    You can't compare them.

    Data Flow Task is a container for other tasks.

    The Execute SQL Task is a narrow purpose task that speaks for itself.

    Also "better" is always depends pertaining to everything and does not work always, one should not stuck to one thing or another, but adopt to circumstances.


    Arthur

    MyBlog


    Twitter

    • Proposed as answer by Albert_ Zhang Monday, March 20, 2017 4:24 PM
    • Marked as answer by Vinod Ulava Thursday, November 21, 2019 7:51 AM
    Tuesday, March 14, 2017 2:44 PM
  • Thank you 
    Friday, March 31, 2017 5:13 AM
  • Thank you
    Friday, March 31, 2017 5:13 AM
  • Thank you
    Friday, March 31, 2017 5:13 AM
  • Hi ulava,

    If some of above replies are helpful to you, please mark them as answers to close this thread and help others easily to find the useful suggestions. Thank you for your understanding and support.

    Best Regards,

    Albert Zhang


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Friday, March 31, 2017 5:20 AM
  • Data flow task :-

    Most of ETL operations are performed in DFT. As the name suggest, this task is used to transfer the data from source to destination. While transferring the data, operations like merge, merge join, data conversion etc. can be performed. This whole process involves Extracting the data from source, Transformation of data in the form expected in destination and then Load the data into destination which is nothing but ETL.

    Execute sql task:-

     show different types of usage for the task:

    • Returning a single value from a SQL query with two input parameters.
    • Returning a rowset from a SQL query.
    • Executing a stored procedure and retrieveing a rowset, a return value, an output parameter value and passing in an input parameter.
    • Passing in the SQL Statement from a variable.
    • Passing in the SQL Statement from a file.


    Please Mark it as Answered if it answered your question OR mark it as Helpful if it help you to solve your problem.

    • Marked as answer by Vinod Ulava Thursday, November 21, 2019 7:51 AM
    Friday, March 31, 2017 5:38 AM