The script threw an exception: Exception of type 'System.OutOfMemoryException' was thrown
Hi everyone I am new to SSIS and this is what i am getting when trying to process .csv file in to database. Can any one let me know why this is happening. This is not happening all the times. Error: The script threw an exception: Exception of type 'System.OutOfMemoryException' was thrown
December 31st, 2010 12:07am

we need more detail, what is the actual code operation that raises this exception. use try catch block inside the script. Please share your package functionality, are you using any for loop in your package?? Let us TRY this | My Blog :: http://quest4gen.blogspot.com/
Free Windows Admin Tool Kit Click here and download it now
December 31st, 2010 1:56am

Post the script code that you use.SSIS Tasks Components Scripts Services | http://www.cozyroc.com/
January 2nd, 2011 9:30pm

Hi Srismiles, The exception of type 'System.OutOfMemoryException' was thrown when there was no enough avaiable physical memory in the server. If the CSV file is large(size), and there are a lots of Partially blocking transformations(such as Merge Join, UNION ALL) or Blocking transformations(such as Sort, Aggreagte) in the SQL Server Integration Services(SSIS) package, the memory required is many times of the file size. This may cause the server to be out of memory. In this case, in order to solve the issue, please try to use two or more packages to import the data into SQL Server instead of using only one pacakge. Or, please try to change the DefaultMaxBufferRows and DefaultMaxBufferSize settings to solve the issue based on the following article: http://technet.microsoft.com/en-us/library/cc966529.aspx If there is anything unclear, please feel free to ask. Thanks, Jin Chen Jin Chen - MSFT
Free Windows Admin Tool Kit Click here and download it now
January 3rd, 2011 2:38am

if you are using Sort, UNION All , aggregate control it tends eat up your memory. Best advise is try to stage this data into sql server table directly and then by executing procs try to achive your target.Blog: http://dineshasanka.spaces.live.com
January 3rd, 2011 5:56am

Yeah it is a master package which in turns calls some child packages.. We do have loops in the packages, can you suggest me how do you want me to share the package
Free Windows Admin Tool Kit Click here and download it now
January 5th, 2011 11:11pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics