June 28, 2012 at 9:21 am
DTSRun: Loading...
DTSRun: Executing...
DTSRun OnStart: DTSStep_DTSDataPumpTask_1
DTSRun OnError: DTSStep_DTSDataPumpTask_1,
Error = -2147467259 (80004005)
Error string: Unspecified error
Error source: Microsoft Data Transformation Services (DTS) Package
Help file: sqldts80.hlp
Help context: 4700
Error Detail Records:
Error: -2147467259 (80004005);
Provider Error: 0 (0)
Error string: Unspecified error
Error source: Microsoft Data Transformation Services (DTS) Package
Help file: sqldts80.hlp
Help context: 4700
DTSRun OnFinish: DTSStep_DTSDataPumpTask_1
DTSRun: Package execution complete.
Process Exit Code 1.
The step failed.
I'm trying to install from a scheduled job......
That may or I'm missing? ........
July 3, 2012 at 10:33 am
Can you run it in BIDS on the box you are getting this error?
CEWII
July 3, 2012 at 10:44 am
Or enable detailed logging.
July 3, 2012 at 11:31 am
no, this dts it migrate from SQL 2000 and do not use the BIDS, install SQL Server 2000 DTS Designer Components for SQL Server 2005 and I can see the design of the DTS and run it without any problem.
The problem arises when I try to run a scheduled job.
July 3, 2012 at 11:34 am
In regards to whether I have enabled Loggin Details.
After running I can see the Job Jobs history and view the problem of DTS.
July 3, 2012 at 11:35 am
Job history isn't detailed logging. You can enable logging inside the package to a text file.
July 3, 2012 at 12:16 pm
Already enable the Log Package and received this:
The execution of the following DTS Package succeeded:
Package Name: ExportaKmsJDE
Package Description: (null)
Package ID: {C4656E95-402E-4982-883A-742234FFDF2C}
Package Version: {B819B9B1-C4C8-4AB9-A70E-C6346D1FE55F}
Package Execution Lineage: {20BF3170-834C-4B96-B8F1-1107348CBFC4}
Executed On: SRVTD7
Executed By: adminmav
Execution Started: 03/07/2012 01:00:32 p.m.
Execution Completed: 03/07/2012 01:08:12 p.m.
Total Execution Time: 459.735 seconds
Package Steps execution information:
Step 'DTSStep_DTSDataPumpTask_1' succeeded
Step Execution Started: 03/07/2012 01:00:32 p.m.
Step Execution Completed: 03/07/2012 01:08:12 p.m.
Total Step Execution Time: 459.656 seconds
Progress count in Step: 14295
Already enable the Log Package and received it and I have no problem:
The problem is when run from a scheduled jobs running:
operating system (CmdExec)
dtsrun / Sen3jde / Uxx / Pxxxxxx / NExportaKmsJDE
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply