Frustrated with DTS! Help 
Author Message
 Frustrated with DTS! Help

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... - - [16/May/2000:23:59:18 -0700] "GET /home.html" 200 13940 "-"
"-" - - [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

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.

Mon, 04 Nov 2002 03:00:00 GMT
 [ 1 post ] 

 Relevant Pages 

1. vb.Net is very frustrating - HELP!!!!!

2. SQL Mail (Help! - Frustrated)

3. Tired...Frustrated..Confused...Please Help

4. Need Help Am Frustrated


6. Hrmm, dont know if this is right but it sure has me frustrated, Help Please

7. DTS Package won't schedule / Help with DTS

8. DTS Package won't schedule / Help with DTS

9. Newbie to SQL7/DTS - Need help with DTS question

10. Visual Basic, DTS, and that DTS Help file

11. Frustrating Decimal Question

12. Q: authorization/security (frustrating!)

Powered by phpBB® Forum Software