I am new to SSIS and am developing a package which takes input from an XML file and then populates an existing SQL table with these records. However, this is a very large XML file. I keep getting an Out of Memory exception. (This file is
210 MB)! So what I tried doing was separating this XML file into 8 smaller files.
Now, I can successfully load data from these smaller files one at a time. But how can I do all of them in the same package? I connected two XML tasks to the Data Flow task and get the error below. I also increased my timeout and number
of errors to no avail. Advice?
Error: 0xC002F304 at XML Task 1, XML Task: An error occurred with the following error message: "Exception of type 'System.OutOfMemoryException' was thrown.".
Task failed: XML Task 1
Warning: 0x80019002 at zSkywardEnrollment: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (1) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors
reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.
Error: 0xC002F304 at XML Task, XML Task: An error occurred with the following error message: "Exception of type 'System.OutOfMemoryException' was thrown.".
Task failed: XML Task
SSIS package "
View Complete Post