April 12, 2006 at 1:09 pm
This started happening today: I try and execute my main package (which calls several others) and visual studio crashes. Has been happening about every other time I run the package this afternoon.
The only thing I can find on MSDN for the error that comes up is "You may have problems editing a 2003 project in 2005" there's no mention of SSIS projects and this issue I can find.
Is anyone else having this?
SSIS Packages, SQL Server, Databases are all local. thanks!
Skål - jh
April 15, 2006 at 9:50 am
Visual Studio crashes. That's what it does.
Sometimes, it just takes a really long time to run massive packages (especially during the validation process), and it will hang if you try to perform other operations. So, it may be a good idea to test them when you have lots of spare time so you can walk away and check back later. If it's still hanging, you may want to just break the packages apart so it isn't trying to do so much at once.
Good luck
April 19, 2006 at 11:03 am
I have had similar problems. More memory seems to help. I upgraded my development machine to 1Gb and it appeared to run better. On one server with 2* 3.2 processors and 2Gb of memory I haven't had a crash (yet).
April 20, 2006 at 6:21 am
2gb of memory is the trick. I found the same thing during the beta. My machine last year only had 1gb and it was crashing regularly. I wrote it off to the beta, but then, when I went to MS class, they required me to have 2gb on the machine. After the upgrade, all the crashes went away (well, most of them).
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply