Tuesday, 2 February 2021

SSIS : Package execution completed.Click here to switch to design mode, or select stop debugging from debug menu

 Hi All,

After 4 or 5 long years when I got a  task to work on SSIS, I was so exited. But when I ran the package I came across this error for first time

I had two "For Each Container". So parallel execution should have worked. But when the container is run individually the package gets completed.


Upon further research, I was able to understand that since both the containers were pointing to same excel file but of different sheet, this error happened. So I have kept two different packages for each of the container and Bingo!! Issue is fixed 

No comments:

Post a Comment