i have a dts package that when I excute from the DTS local it runs in about
10 min or so.
But when I schdule the package to run as a JOB it takes 30 + min

what am I doing wrong

You need to have a look at the resources used on the server and what the
server is doing at the time of execution. DTS is a client application so
when you run it everything is local to you but in a scheduled job it is run
on the server. Because it is a server you may be seeing

Contention for server resources
AND/OR
Resources in the package being retrieved latency

etc etc



--



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


"ljhopkins_LOST and Cant find My Way" <ljhopkins_LOST and Cant find My
Way (AT) discussions (DOT) microsoft.com> wrote