[dba-SQLServer] BCP error too generic

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
www.ColbyConsulting.com


Martin Reid wrote:
> http://blog.cybner.com.au/2007/09/cannot-fetch-row-from-ole-db-provider.html
> 
> 
> 
> Martin WP Reid
> Information Services
> The Library at Queen's
> Tel : 02890976174
> Email : mwp.reid at qub.ac.uk
> ________________________________________
> From: dba-sqlserver-bounces at databaseadvisors.com [dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of jwcolby [jwcolby at colbyconsulting.com]
> Sent: 14 October 2009 14:03
> To: Dba-Sqlserver
> Subject: [dba-SQLServer] BCP error too generic
> 
> I am getting a failure to import (BCP) some line in a file.  When that happens the process just
> fails with an error
> 
> "cannot fetch a row from OLE DB provider "BULK" for linked server "(null)"
> 
> Is there any way to get the row number that triggered the failure?  Or anything else even slightly
> more useful than this pretty darned useless error message?
> 
> --
> John W. Colby
> www.ColbyConsulting.com
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
> 
>