Hi there, I am trying to import some standard Weblog data into SQL Server
7.0 using DTS every night from our webservers.

The few lines of the source file look like this...

192.168.30.1 - - [16/May/2000:23:59:18 -0700] "GET /home.html" 200 13940 "-"
"-"
192.168.30.1 - - [16/May/2000:23:59:18 -0700] "GET /home.html" 200 13940 "-"
"-"

Now, because of the funkiness of the delimiters in the source file
(brackets, quotes on some fields, not on others, etc.), I've set up my
column delimiter as a space character and have enabled quoted text strings.
Also, the row delimiter is a simple LineFeed, not a CR/LF.  From there, I'm
splitting/merging fields using ActiveX transformations and writing to a
table in the database.

This process has been working flawlessly for over two weeks.  However, just
today I received a "Column Delimiter not found" error 3/4 of the way through
the file.  When I look at the row that failed, it looks exactly the same as
the prior 5 rows in the file.  I even dumped the file into Codewright and
viewed as hex to make sure that character-by-character the lines were the
same.

So,  does anyone know why DTS would arbitrarily fail like this?  Is this a
known problem?

I'm completely at a loss right now.  I don't know what else to do.

Any help would be appreciated.