Which is a better way to do in Execute SQL Task : Direct SQL input or Create a stored proc in database and then use that.
In my opinion, Stored Procedure is a better and recommended way for following reasons:
- Cached execution plan
- More secure
- Centralized code
- Code reuse
Please let me know if this is not the case with SSIS Execute SQL Task.
View Complete Post