Can any one please help explain why this error has happened, it is not a normal error of SSIS,
"SSIS Debug host has encountered a problem and needs to close. We are sorry for the inconvenience"
It has 2 buttons Debug and Close, this error happened in the middle of a script task.
This is a classic Microsoft problem. I face this problem often.
These are the scenarios on which I usually get this probelm:
1. If there is less memory on the client system where VB studio is open, and trying lot of mouse clicks frequently.
2. It is observed more when in Debug mode, when you try to scroll using the middle wheel of the mouse.
After I upgraded my desktop RAM to 3GB, and often system restart at the start of the day, I observed this error is less.
Also always saving and building frequently of the packages will help to retain your work. Other than these, there is no real solution from what I observed.
No comments:
Post a Comment