You might get the following error after trying to run a long or I/O intensive SSIS package while using the VS 2008 IDE, and starting the package by doing a Debug>>Start Debugging.

EventType clr20r3, P1 devenv.exe, P2 9.0.30729.1, P3 488f2b50, P4 system.windows.forms, P5 2.0.0.0, P6 4889dee7, P7 601e, P8 0, P9 system.outofmemoryexception, P10 NIL.

Two options here – either fix the package, or try running by doing Debug>>Start Without Debugging.  (That’s where the DOS window pops up).  Using this method it won’t run your IDE out of memory.

 

Lee Everest

 

----------------------

I’m going to try option one starting tomorrow. It’s a real jim-dandy right now.

Statue


Posted in: SSIS  Tags:
blog comments powered by Disqus

by Lee Everest, M.S.

Info

Poll

Do you use Azure or cloud in your organization?



Show Results

Ads

Search


Month List

Calendar

«  May 2012  »
MoTuWeThFrSaSu
30123456
78910111213
14151617181920
21222324252627
28293031123
45678910
View posts in large calendar

Tags

Disclaimer
The opinions, code, examples, et.al. expressed herein are my own personal opinions and do not represent my employer's view in any way, shape form, or fashion.  All code for demonstration purposes - no guarantees, either written or implied, are made.

© Copyright 2012 Lee Everest's SQL Server, etc. weblog