|
I've taken the log files from my site and am trying to Bulk insert them into my database. I've got the tables set up properly. Here's the issue, at the beginning of each entry there are four lines all starting with #, which is supposed to be comments and apparently are supposed to be ignored. This is not the case. If I remove these lines everything works great, if I leave them in I get data type miss match errors as if it's reading the commented lines.
BULK INSERT WebLogs FROM 'C:\filepath\ex090701-97.74.144.4.log'
WITH (FIELDTERMINATOR = ' ', ROWTERMINATOR = '\n')
Is there anything I'm missing.
|
