July 12, 2011 at 1:42 am
Hi,
In my system, i have VS 2005. I have SSIS Packages and i am working on this last 6 month. Since from last week my packages taking too much of time to open and also for running the same. Can guys tell me how to solve this?
Each time, i am getting Microsoft busy with internal operations message.
Is there any patch that i need to update?
---
July 12, 2011 at 1:58 am
There are some many things that can cause this.
Do you open all the packages at the same time?
Do you use a lot of package configurations?
When SSIS opens a package, it will validate that package, so if you open quite a lot of packages this can take some time.
Maybe it is just your computer that is running slow. Do you have enough RAM? Do you restart it from time to time?
Regarding slow execution times, that is something that should be looked at for each package specifically. But execution times in BIDS itself are not representative. You can only truly performance test by using the DTEXEC command line tool.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 12, 2011 at 6:52 am
No Koen. I didn't open all the package at a time and i have only one configuration in it. Even for a small package also it takes time to open.
But if i open the same package it goes smooth. 🙂 It happen in my system only. Can you tell me what are the reasons behind this?
July 12, 2011 at 7:16 am
If it happens only at your system, you should take a good look at your computer. Is there enough RAM?
Maybe you can try to re-install BIDS.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 12, 2011 at 7:21 am
Perhaps you could also try a system restore to when your system was working well - assuming you have a suitable restore point, of course.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
July 13, 2011 at 1:22 am
Koen Verbeeck (7/12/2011)
If it happens only at your system, you should take a good look at your computer. Is there enough RAM?Maybe you can try to re-install BIDS.
Even, it was working fine early before and i have re-installed my BIDS. But i have noticed that, last week my IT team did some patch update. May be because of this causing this type of issue.
But sometimes i am getting The objects invoked has disconnected from clients error. Is this because of my patch update?
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply