Showing posts with label threshold. Show all posts
Showing posts with label threshold. Show all posts

Wednesday, March 21, 2012

Out of Memory

Hi,

Is there a maximum threshold for the objects that I can place in 1 package? I'm encountering an intermittent out of memory in IS. And if I am able to run the project, it hangs the processing of the objects.

any idea how i can resolve this?

cherriesh

Not sure if there is a maximum (maybe one of the MSFT SSIS team could comment), but I've never encountered one. How large is the package? I've found it is better to break really large packages into smaller ones (< 1.5 mb in size).|||ic... mine has reached 10 mb...