Re: Slow DTS Package on server-side

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Allan Mitchell (allan_at_no-spam.sqldts.com)
Date: 12/04/04 

Date: Sat, 4 Dec 2004 21:42:33 -0000

OK

DTS is a client application so DTS will look for resources in relation to
the place of execution. When you are sat on your PC in EM and open a
package on the server then the package is no longer at the server it is at
your PC. When a DTS package is scheduled then it executes on the scheduling
server.

Resources then are in relation to the executing box and it may be that the
server takes longer to retrieve those resources than you do from your PC. 

-- 
Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good.  here we show you the new stuff.
www.konesans.com - Consultancy from the people who know
"Martin" <mdeslandes@ratiopharm.ca> wrote in message 
news:uUG9KUj2EHA.2112@TK2MSFTNGP15.phx.gbl...
> Hi,
>    Since 2 weeks, we have a problem with SQL Server 2000. We have defined 
> a
> schedule job in witch we execute about 100 dts packages. This job usually
> take about 2h30 to run but since 2 weeks, it takes about 8 hours. I've
> noticed that if I execute a particular step on the server, it takes 1h30 
> to
> run. And if I connect to the server by enterprise manager and I start the
> DTS package on the server from my PC, it takes 20 minutes (witch is the
> normal time to run). We have installed MDAC 2.8 on the server 2 weeks ago,
> so I thought this was the problem, but I successfully rollback the version
> of MDAC to 2.7 using the dasetup.exe /u command and we still have the
> problem.
>
> Thanks in advance,
> Martin
>
> Server configuration:
>
> Windows 2000 server sp4
> SQL server 2000 Enterprise sp3
> Office 2000
>
>

Relevant Pages

  • RE: DTS fails to import data when called from VB6
    ... have also installed MS Access on the server. ... Within the VB code I execute 2 DTS packages ... Note that if the DTS packages are executed manually on the ... >> I have created a DTS package that imports an Access ...
    (microsoft.public.sqlserver.dts)
  • Re: DTS Failed
    ... Have the DTS package itself and the DataPump tasklog to text file as ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... > DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_11 DTSRun OnStart: ...
    (microsoft.public.sqlserver.dts)
  • Re: Scheduling DTS to run every hour Until text file is loaded
    ... trigger to auto-schedule a job. ... TargetServersRole has been denied execute permissions on the sproc. ... > existence of a file in DTS, and if not exit the package. ... > tweak the job schedule from inside the DTS package after the file has been ...
    (microsoft.public.sqlserver.dts)
  • Re: DTS vs Job Problem for 2 Digit Date format
    ... The DTS & The job is execute directly on the server? ... Norm ... When you execute a DTS package it comes to you. ...
    (microsoft.public.sqlserver.dts)
  • Re: Executing DTS from Code (correction)
    ... Granting execute permissions on these procs means that external Com objects can be called etc. ... If they run in-process and crash then bye-bye SQL Server. ... I moved the DTS package to the production server and>>> installed the application on the production server. ...
    (microsoft.public.sqlserver.dts)