BULK INSERT Help needed bad!

Morning all,

The following cmd says it executed but no rows appear in DB table.
I am running this cmd in QA on the server. The data file is on the server too.

BULK INSERT dbo.TBL_Master_DoNotCallList_Loader
FROM 'E:\SqlServerBackups\National Do Not Call List\VT_31_8_2006.txt'
WITH (FIELDTERMINATOR = '~')

Data looks like this:
8022028492~8022171040~8022172021~8022211006~802221 1017~8 ect

This is what QA comes back with: The command(s) completed successfully.

What am I missing here ?
Thanks
DeasunNever mind.
Found out our test server has problems.
Production server ran cmd no problem.|||

Quote:

Originally Posted by tirnaog

Never mind.
Found out our test server has problems.
Production server ran cmd no problem.

Hi,

I just got the same problem on my test server which used to work just fine.
Just wonder whether you did discover the root cause of the issue and how to fix it?
I re-patch the SQL instance with SQL service pack 4 but did not help...

Thanks,
John