I have a DTS 2000 package that I am trying to run as an automated job in SQL
2005. The DTS 2000 package is run as an “Execute DTS 2000 Package” step in
and SSIS package. That’s the only step in the package.

If I simply click on the package, the Execute Package Utility runs the SSIS
package to completion. If I open the package with the Business Intelligence
Development Studio, it runs to completion.

If I create a SQL Server Agent job, and run by choosing Start Job, the job
fails, simply saying “Execution of job failed. See history log for details.”
I’m not seeing any details in the history log, so I turned on logging in the
package. The relevant portion of that log file is shown below. Can anyone
point me in a useful direction?
OnProgress WNC-SQL2 NT AUTHORITY\SYSTEM Execute DTS 2000 Package
Task {545D315D-0F5A-4992-B88B-98F645CA7B37} {A08C02FA-5FE4-4A03-A492-EBDBA8CD221F} 7/26/2006
14:27 7/26/2006 14:27 0 0x Execute DTS 2000 Package Task is initiated
OnError WNC-SQL2 NT AUTHORITY\SYSTEM Execute DTS 2000 Package
Task {545D315D-0F5A-4992-B88B-98F645CA7B37} {A08C02FA-5FE4-4A03-A492-EBDBA8CD221F} 7/26/2006
14:27 7/26/2006 14:27 0 0x System.Runtime.InteropServices.COMException
(0x80040427): Execution was canceled by user.
at DTS.PackageClass.Execute()
at
Microsoft.SqlServer.Dts.Tasks.Exec80PackageTask.Ex ec80PackageTask.ExecuteThread()
OnError WNC-SQL2 NT
AUTHORITY\SYSTEM ACS_Build {63AB083C-5AFE-4BD6-9552-044169A9F466} {A08C02FA-5FE4-4A03-A492-EBDBA8CD221F} 7/26/2006
14:27 7/26/2006 14:27 0 0x System.Runtime.InteropServices.COMException
(0x80040427): Execution was canceled by user.
at DTS.PackageClass.Execute()
at
Microsoft.SqlServer.Dts.Tasks.Exec80PackageTask.Ex ec80PackageTask.ExecuteThread()
OnProgress WNC-SQL2 NT AUTHORITY\SYSTEM Execute DTS 2000 Package
Task {545D315D-0F5A-4992-B88B-98F645CA7B37} {A08C02FA-5FE4-4A03-A492-EBDBA8CD221F} 7/26/2006
14:27 7/26/2006 14:27 100 0x Execute DTS 2000 Package Task is completed
OnTaskFailed WNC-SQL2 NT AUTHORITY\SYSTEM Execute DTS 2000 Package
Task {545D315D-0F5A-4992-B88B-98F645CA7B37} {A08C02FA-5FE4-4A03-A492-EBDBA8CD221F} 7/26/2006 14:27 7/26/2006 14:27 0 0x (null)
OnPostExecute WNC-SQL2 NT AUTHORITY\SYSTEM Execute DTS 2000 Package
Task {545D315D-0F5A-4992-B88B-98F645CA7B37} {A08C02FA-5FE4-4A03-A492-EBDBA8CD221F} 7/26/2006 14:27 7/26/2006 14:27 0 0x (null)
OnWarning WNC-SQL2 NT
AUTHORITY\SYSTEM ACS_Build {63AB083C-5AFE-4BD6-9552-044169A9F466} {A08C02FA-5FE4-4A03-A492-EBDBA8CD221F} 7/26/2006
14:27 7/26/2006 14:27 -2.1E+09 0x The Execution method succeeded but the
number of errors raised (1) reached the maximum allowed (1); resulting in
failure. This occurs when the number of errors reaches the number specified
in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.