Reputation: 1559
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
Upvotes: 0
Views: 479
Reputation: 3964
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
Upvotes: 1