>I'm trying to do a bulk insert:
>
>
>BULK INSERT Import
> FROM 'c:\data.txt'
> WITH
> (
> FIELDTERMINATOR ='|',
> ROWTERMINATOR = '\r\n'
> )
>
>
>I'm only getting the first row from the text file.
Did you try to use \n for ROWTERMINATOR instead?
If it's not broken, fix it until it is.
My Blog 
