Recently I face this issue. My stored procedure is completed successfully in the database but in the package Execute SQL task is still executing. I did some R&D and found that this was basically because we were using few Print statements in SQL stored procedures and as we were executing this stored procedure from SSIS it might be creating some buffers which were being cleared after execution. I commented Print statement in my stored procedure and execution time in SSIS is same as execution time in SSMS.
Best practices: Don’t use print statement in SP while we are using it in the SSIS.
No comments:
Post a Comment
If you have any doubt, please let me know.