[dba-SQLServer] BCP error too generic

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