using SSIS loading xml and having memory problems



I am importing a very complex XML to Sal server using SSIS. I am using the same schema for Over 2000 XML. I have it n a for loop looping to all of the files in a folder. The problem is that The first file Takes about .5 sec to load. But by the 300 file it takes about 12 sec and then progressively gets worse. I have tried to clear the memory by adding a step



DBCC FREESYSTEMCACHE
DBCC FREESESSIONCACHE


in the forEachloop but this does not help.


No comments:

Post a Comment