[dba-VB] [dba-SQLServer] Bulk Insert Error.

ROTFL.  Naw, I'm still a complete nubee and so any suggestion is better than
what I know. 


John W. Colby
Colby Consulting
www.ColbyConsulting.com 
-----Original Message-----
From: dba-vb-bounces at databaseadvisors.com
[mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of
max.wanadoo at gmail.com
Sent: Friday, September 21, 2007 2:23 PM
To: dba-vb at databaseadvisors.com
Subject: Re: [dba-VB] [dba-SQLServer] Bulk Insert Error.

I was going to suggest that but I thought you might think I was stupid!

Max
 

-----Original Message-----
From: dba-vb-bounces at databaseadvisors.com
[mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: Friday, September 21, 2007 7:13 PM
To: dba-sqlserver at databaseadvisors.com
Cc: 'VBA'
Subject: Re: [dba-VB] [dba-SQLServer] Bulk Insert Error.

Well, it appears that it was a simple issue of the field size being too
small.  It was not intermittent at all, my catch was causing the entire
function to exit which caused the next file to run which had the same error
but at a different record (of course!).  Once I traced it down to stopping
at exactly the same record every time I decided to go open up the field size
for that field (and about 4 similar fields) and the import is happily
running now. 



John W. Colby
Colby Consulting
www.ColbyConsulting.com