>>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?
I played around with Bulk Insert a few weeks ago. In addition to what Naomi mentioned, you may want to check your rows to see if there is a "|" at the end of the row also. If there is, you will have to figure for that in your ROWTERMINATOR property.