[dba-SQLServer] BCP error too generic

jwcolby jwcolby at colbyconsulting.com
Wed Oct 14 12:38:49 CDT 2009


Yea, so I see.

John W. Colby
www.ColbyConsulting.com


Robert Stewart wrote:
> BCP will only import clean, structured data.
> 
> 
> At 12:00 PM 10/14/2009, you wrote:
>> Date: Wed, 14 Oct 2009 09:43:29 -0400
>> From: jwcolby <jwcolby at colbyconsulting.com>
>> Subject: Re: [dba-SQLServer] BCP error too generic
>> To: Discussion concerning MS SQL Server
>>         <dba-sqlserver at databaseadvisors.com>
>> Message-ID: <4AD5D581.6000306 at colbyconsulting.com>
>> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>>
>> Yea, I saw this and about 47 million other posts for this error 
>> message.  It appears that if
>> ANYTHING (and I do mean ANYTHING) goes wrong in the import, BCP 
>> fails with this error message.  The
>> data I am trying to import is just full of trash.  empty fields, 
>> rows without the correct number of
>> fields etc.  It is no wonder BCP complains.
>>
>> I was just hoping to get more info but it seems that is a dream.
>>
>> John W. Colby
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
> 
> 



More information about the dba-SQLServer mailing list