BULK LOAD problem

[pandatime]

Hi,

I am trying to load a file using bulk load. It's only loading EXACTLY one-half of the rows in the file! Exactly one-half to the letter.

I'm looking at the data in the file, but there NO difference between the first half and the second half whatsover.

What could be the problem?

Here is my bulk load stmt:

exec('
BULK INSERT
myTable
FROM ''E:\myFile.txt''
WITH
(
FORMATFILE = ''E:\format.fmt'',
TABLOCK,
ERRORFILE = ''E:\error.txt''
)')

Thanks

 

[pandatime]

Nevermind...! Figured out what the problem was. doh