Using Garbage Collection after import

[SteveB]

Hi All,

I am using the SqlBulkCopy for import data into ms sql 2005. I need to
import multipe files which could be from 1 to GB each. Is there need to use
a garbage collection for this purpose since the files are pretty big.

Here is class for the garbage collection:
http://msdn.microsoft.com/en-us/library/xe0c2357.aspx


Thanks,

Steve

 

[George Shui]

I guess you use DataTable as a param in BulkCopy.

Could you try DataTable.Clear() method to free the memory?