There are a number of things that can be going wrong here

1. Permissions are different when manual v scheduled.

http://support.microsoft.com/?kbid=269074

and

2. http://support.microsoft.com/?kbid=290077

Also

try setting the package's tasks to execute on the main thread as well



--

----------------------------

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


[quoted text, click to view]

Hi,

I have a DTS that is scheduled.
The package it runs will run perfectly while running manually
but when scheduled, it appears to get stuck on the first step till i
manually stop it.
then in the job history i would see 'job was canceled'

help?