Execute SQL task with T-SQL query and with stored procedure in SSIS

Question

In SSIS Execute SQL Task currently I am calling a stored procedure and inside the procedure I have a MERGE statement.

Is there any difference if I call that query (T-SQL MERGE) directly in the Execute SQL Task? (are there any differences like Log will create if we used SP?)

Please reply me...

Thanks in advance

Daryl Wenman-Bateson · Accepted Answer · 2011-08-17 12:14:57Z

1

Stored procedure will provide you with a more maintainable solution as you will be able to leverage code reuse and there will be no need to change / re-release the package if your query logic changes

A stored procedure is also likely to provide you with the fastest execution time as it will be compiled and the execution plan will be reused on subsequent runs

answered Aug 17, 2011 at 12:14

Daryl Wenman-Bateson

3,9541 gold badge23 silver badges39 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Execute SQL task with T-SQL query and with stored procedure in SSIS

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related