[thelist] SQL2k: BULK INSERT not failing but also not creating row

Matthieu Guyonnet-Duluc list at deuxtowers.com
Sat Nov 23 16:57:01 CST 2002


> -----Message d'origine-----
> De : thelist-admin at lists.evolt.org
> [mailto:thelist-admin at lists.evolt.org] De la part de Joshua Olson
> Envoyé : samedi 23 novembre 2002 15:59
> À : thelist at lists.evolt.org
> Objet : [thelist] SQL2k: BULK INSERT not failing but also not
> creating row
>
>
> Hi gang,
>
> On SQL Server 2k I'm using BULK INSERT to import a tab
> delimited text file into a table.  After I got the row and
> column delimiters worked out, the code didn't error in Query
> Analyzer but for some reason there are still no rows in the
> table.  Any thoughts?  The T-SQL code is as follows:
>

Hi joshua,

Do you tried to use the import data wizard with text file as data source
? Maybe there's a option that you'll discover and will resolve your
problem.

Matthieu




More information about the thelist mailing list