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...

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.



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

5. REALLY FRUSTRATED. PLEASE HELP

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