Error Importing CVS into SQL Server 2005 using SQLBulkCopy and c#

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rob Dob - 26 Apr 2007 00:32 GMT

Hi,

I'm using SQLBulkCopy via c#, I'm importing a large text file into a
destination SQL Table, the file contains multiple columns and is about 100k
records, I am getting the following error:

'Could not allocate space for object 'dbo.list0001'.PK_List001Table' in
database 'E3232323\43343434_\34343\MyDatabase.mdf because the 'PRIMARY'
filegroup is full. Create disk space be deleting unneeded files, dropping
objects in the filegroup, adding additional files to the filegroup, or
setting autogrowth on the existing files in the filegroup.

Can someone please tell me how to resolve this?

Thanks

Reply to this Message

John Bell - 26 Apr 2007 08:42 GMT

Hi Rob

> Hi,
>
[quoted text clipped - 11 lines]
>
> Thanks

The error message is probably correct! You have either a fixed file size for
the database file, or there is not enough disc space for the file to grow by
the expected value. This may be because you have a percentage growth set and
it is therefore trying to expand by an enormous amount or you just don't have
enough space available.

John

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...