DTS runs very slow

  • Hi, My DTS packages are running too slow since last week. They have been running very fast until last week without any problem. We installed NT service pack 3 last week. Does it cause any slowdown ?

  • I won't claim to be an expert, but I don't think upgrading to NT SP 3 would slow down your DTS packages.

    Did anything else change on your network? Were all computers on your network upgraded? I would think there were some other changes on the network caused by the upgrade that slowed down your packages. Perhaps some network routes changed or got removed along with the upgrade. Granted, I am guessing, but more often than not when my DTS packages slow down and I haven't made any changes to them, it is usually because of some network change.

    Robert Marda

    SQL Server will deliver its data any way you want it

    when you give your SQL Programmer enough developing time.

    Robert W. Marda
    Billing and OSS Specialist - SQL Programmer
    MCL Systems

  • I agree with Robert, the SP itself should not cause issues but something could have stepped on the Winsock stack or the network configuration during the install.

    "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply