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