I am running a SSIS script that was working fine last Friday. All of a sudden this week the script stops half way through. There is no errors and it says it completed successfully. I am not sure how this is possible since it is only half way through the process flow. Looking at the Progress tab is shows the remaining items as: Task Insert Import Validation has started Validation is completed There is no actual starting of the task. Has anyone seen this before or have any ideas why it might just stop working all of a sudden without any errors? The point at which it stops is after a stored procedure call where it is supposed to run a precedence contraint.

Hello, When you say it is half way stopped , what does that mean? Do you mean that scrip task executes few lines of code and then stops? Open your package in BIDS and then debug , in script task print different status statements to figure our what is happening. you can use MessageBox.Show() to print during debugging. Thanks

I have found the problem. The script was stopping after a certain task in the middle of the flow and the output window was saying that the script was completed successfully despite not finishing all the tasks. I found that the problem was the return variable in the task. Somehow the line of code in my stored procedure which populated the return variable was removed. Therefore it was returning nothing and the SSIS script stopped. I am not sure why it didn't continue to the next step because it should continue of success. Hopefully this will help anyone else having this problem in the future.