[thelist] Re: SQL2k: BULK INSERT not failing but also not creating row
Joshua Olson
joshua at waetech.com
Mon Nov 25 22:17:01 CST 2002
----- Original Message -----
From: "Nick Baker" <nbaker at educationau.edu.au>
Sent: Monday, November 25, 2002 6:56 PM
> what rowterminator values did you use? try using '\n' rather than '\r\n'.
>
> nick
Thanks for the idea. I generated the text file with vbCRLF's at the end of
the rows. The BULK INSERT command failed predictably with an error when I
used the rowdelimiter of '\n'. '\r\n' is the proper delimiter in this case.
To everyone that provided input, thank you. I ended up creating a DTS
package and executing it via dtsrun.exe. IOW... I gave up.
Thanks.
-joshua
More information about the thelist
mailing list