Re: DTS Sucess but fails to go to next step when scheduled

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

Date: Mon, 20 Sep 2004 18:55:11 GMT

OK so the error only happens when scheduled so try this

Wh is the job owned by ?

If == a member of the sysadmin role then log in as the account under which the
SQL Server Agent Service logs in. Now try the package

If != A member of the sysadmin rol then log in as the proxy ac*** and try the
package. 

-- 
Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know