Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003
    Location
    Netherlands
    Posts
    98

    Lightbulb Need some advice

    Hi,

    I must design a dts or somelike that does the following!

    We have 2000 machines in europe which sends logfiles every hour to an ftpserver at our main office, the logfiles are in xml format!
    What is the best and more important stabil way to get these record into the SQL 200 server? The logging from the machine goes on 24/7 and the amount of machines is growing every day.

    I used an dts script to import the files from the ftp but it is totally onstable!

    Thanx in front!
    Cheers Wim

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    This strikes me as more of a question for the Microsoft SQL Server forum than here, but I can see why you might post it here too.

    With that said, DTS has been absolutely rock solid for me once I get my packages completely debugged. I've had trouble with packages that violated some rules of Windows/databases that I hadn't discovered yet, but it has been years since I've had a problem that I could trace back to the tool itself (those problems were fixed in SQL 7.0 sp2).

    While you could certainly re-engineer the process, which would make it "fair game" for this forum, but I'd suggest working out the problems with your existing process using DTS. If you decide to work out the problems, I'd strongly suggest taking the issue to the other forum because you'll probably get better answers there.

    -PatP

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •