schedule Execute DTS 2000 Package SSIS and dtexec
- From: Lisa2004 <Lisa2004@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Thu, 8 May 2008 06:41:00 -0700
I have a legncy DTS package when upgrading to SQL 2005, I used "SQL Business
Intelligence Development Studio" to create a project, the control flow is
"Execute 2000 DTS Package", by right click "Execute Task" of the control
flow, the color changed from yellow to red, the message said "package
Execution completed". When I try to schedule this package in SQL Server
Agent, the job failed. When I run dtexec, got following error message.
C:\>dtexec /file "C:\Documents and Settings\lyang\My Documents\Visual Studio
200
5\Projects\TraingDTS\TraingDTS\DTSTraining.dtsx"
Microsoft (R) SQL Server Execute Package Utility
Version 9.00.1399.06 for 32-bit
Source: Execute DTS 2000 Package Task
Execute DTS 2000 Package Task is initiated: 0% complete
End Progress
Error: 2008-05-08 09:13:35.74
Code: 0x00000000
Source: Execute DTS 2000 Package Task
Description: System.Runtime.InteropServices.COMException (0x80040427):
Execut
ion was canceled by user.
at DTS.PackageClass.Execute()
at
Microsoft.SqlServer.Dts.Tasks.Exec80PackageTask.Exec80PackageTask.ExecuteT
hread()
End Error
Progress: 2008-05-08 09:13:35.74
Source: Execute DTS 2000 Package Task
Execute DTS 2000 Package Task is completed: 100% complete
End Progress
Warning: 2008-05-08 09:13:35.74
Code: 0x80019002
Source: DTSTraining
Description: 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 M
aximumErrorCount or fix the errors.
End Warning
DTExec: The package execution returned DTSER_FAILURE (1).
Can anyone tell me what does the error message mean and how to solve them?
Thanks very much in advance!
Lisa
.
- Prev by Date: Unexpected internal error when querying cube data
- Next by Date: DTS packages
- Previous by thread: Unexpected internal error when querying cube data
- Next by thread: DTS packages
- Index(es):
Relevant Pages
|
