Bulk Insert

Tech-Archive recommends: Fix windows errors by optimizing your registry

The file I am attempting to bulk insert has " " around all the text
fields, Bulk Insert is trying to insert the double quotes with the
text, and the error message says:

Error: Bulk Insert fails. Column is too long in the data file for row
1, column 1. Make sure the field terminator and row terminator are
specified correctly. (State:37000, Native Code: 1302)


Any help would be greatly appreciated

.

Relevant Pages

  • Re: does Ado.Net 2.0 have bulk insert functionality?
    ... Bulk ops. ... "Rich" wrote in message ... >> textfiles using a DTS package converted from vb6 to ... >> circumventing this error message with a SendKeys ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Bulk insert help
    ... Ilya ... > I am having some major issues with a bulk insert operation. ... > the row terminator is a new line/carriage return and the field terminator ... > Make sure the field terminator and row terminator are specified correctly. ...
    (microsoft.public.sqlserver.programming)
  • Re: Disabling DTS Bulk insert task
    ... Simon ... "Allan Mitchell" wrote in message ... >> this is the error message i get if i use the disablesetp method with the ... >> bulk insert task. ...
    (microsoft.public.sqlserver.dts)
  • Trapping error messages
    ... I'm making a BULK INSERT opperation from a stored ... BULK INSERT Import ... Let's say there is some error in the format of my text ... Is there a way to trap the above error message that tells ...
    (microsoft.public.sqlserver.programming)
  • Running out of resources when I have a large number of Databases attached.
    ... SP4, the problem is when we get more then about 1400 DB's attached we ... start having backup and Bulk Import issues. ... The Bulk Import error message is: ...
    (microsoft.public.sqlserver.server)