[dba-SQLServer] BCP error too generic

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