I got the following error when my scheduled DTS task run by SQL Agent in Server.
But this package runs fine manually in my workstation via Enterprise Manager.
Anyone know why ?

DTSRun: Loading... DTSRun: Executing...
DTSRun OnStart: DTSStep_DTSExecuteSQLTask_2
DTSRun OnError: DTSStep_DTSExecuteSQLTask_2, Error = -2147217887 (80040E21)
Error string: Errors occurred
Error source: Microsoft OLE DB Provider for SQL Server
Help file: Help context: 0
Error Detail Records:
Error: -2147217887 (80040E21); Provider Error: 0 (0)
Error string: Errors occurred
Error source: Microsoft OLE DB Provider for SQL Server
Help file: Help context: 0
DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_2
DTSRun: Package execution complete.
Process Exit Code 1. The step failed

The error appears to be in this step

DTSStep_DTSExecuteSQLTask_2

Here is a good article which usually solves this type of problem

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

--
--

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

"Bonnie" <bonnie (AT) sina (DOT) com> wrote