Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 .NET Inside SQL Server (2005)
 OutofMemoryException

Author  Topic 

patelb
Starting Member

16 Posts

Posted - 2008-08-05 : 19:11:24
Im getting an OutOfMemoryException when using SqlBulkCopy to transfer data to my DB table. I pass in a DataTable to the WriteToServer() method of SqlBulkCopy. The DataTable is populated from a 70mb CSV file. Can I use SqlBulkCopy to transfer data of that size? I dont know whats causing the error.

jezemine
Master Smack Fu Yak Hacker

2886 Posts

Posted - 2008-08-05 : 19:28:14
if it's already in a csv file, why not just use BULK INSERT or bcp.exe?

DataTable and DataSet are memory pigs.


elsasoft.org
Go to Top of Page
   

- Advertisement -