DTS Package Only Pulling 66,788 Records

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Import/Export (DTS) and Replication (2000)

DTS Package Only Pulling 66,788 Records

Author

Topic

aviator11
Starting Member

4 Posts

Posted - 2009-01-21 : 17:18:42

When I run a DTS package through a scheduled job in SQL Server Agent or using command line, I only get 66,788 records. But when I run the same DTS Package by right-clicking on it under DTS Packages, it runs fine and pulls about 185,000 records. Any idea how to fix it as I am tired of running it every months manually? Thanks

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-01-21 : 17:26:32

Is there an ending time for the job?

E 12°55'05.63"
N 56°04'39.26"

aviator11
Starting Member

4 Posts

Posted - 2009-01-21 : 17:36:12

No, there is no time limit for the job. Same thing also happens when I run the DTS package from command line manually.

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-01-21 : 17:37:36

What does the log say?

E 12°55'05.63"
N 56°04'39.26"

aviator11
Starting Member

4 Posts

Posted - 2009-01-21 : 18:00:58

Here is the error log.... (I am pulling data from AS/400)

Executed as user: NASACT-2KS-DBT1\SQLService. DTSRun: Loading... DTSRun: Executing... DTSRun OnStart: DTSStep_DTSExecuteSQLTask_3 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_3 DTSRun OnStart: DTSStep_DTSDynamicPropertiesTask_1 DTSRun OnFinish: DTSStep_DTSDynamicPropertiesTask_1 DTSRun OnStart: DTSStep_DTSDataPumpTask_3 DTSRun OnError: DTSStep_DTSDataPumpTask_3, Error = -2147467259 (80004005) Error string: [IBM][iSeries Access ODBC Driver][DB2 UDB]SQL0901 - SQL system error. Error source: Microsoft OLE DB Provider for ODBC Drivers Help file: Help context: 0 Error Detail Records: Error: -2147467259 (80004005); Provider Error: 901 (385) Error string: [IBM][iSeries Access ODBC Driver][DB2 UDB]SQL0901 - SQL system error. Error source: Microsoft OLE DB Provider for ODBC Drivers Help file: Help context: 0 DTSRun OnFinish: DTSStep_DTSDataPumpTask_3 DTSRun: Package execution complete. Process Exit Code 1. The step failed.

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-01-21 : 18:08:36

What does the DTS-package log say?

E 12°55'05.63"
N 56°04'39.26"

aviator11
Starting Member

4 Posts

Posted - 2009-01-21 : 21:02:37

Here is the DTS error log... (Thanks for all your help...)

The execution of the following DTS Package succeeded:

Package Name: Lds_Energy_Stats_Source_Detail
Package Description: Import Energy and Stats Balancing Data from LDS
Package ID: {09E67192-474F-4F01-ABA2-1A4EF1059F7D}
Package Version: {4344B759-4CC0-42FE-9929-082A5C16E291}
Package Execution Lineage: {75B505A4-9902-4CFC-935C-1521C2C8DA70}
Executed On: NASACT-2KS-DBT1
Executed By: HaniS0NA
Execution Started: 1/21/2009 7:43:38 PM
Execution Completed: 1/21/2009 7:45:56 PM
Total Execution Time: 138.125 seconds

Package Steps execution information:

Step 'DTSStep_DTSDynamicPropertiesTask_1' succeeded
Step Execution Started: 1/21/2009 7:43:38 PM
Step Execution Completed: 1/21/2009 7:43:38 PM
Total Step Execution Time: 0 seconds
Progress count in Step: 0

Step 'DTSStep_DTSExecuteSQLTask_1' was not executed

Step 'DTSStep_DTSDataPumpTask_1' failed

Step Error Source: Microsoft OLE DB Provider for ODBC Drivers
Step Error Description:[IBM][iSeries Access ODBC Driver][DB2 UDB]SQL0901 - SQL system error.
Step Error code: 80004005
Step Error Help File:
Step Error Help Context ID:0

Step Execution Started: 1/21/2009 7:43:38 PM
Step Execution Completed: 1/21/2009 7:44:04 PM
Total Step Execution Time: 25.844 seconds
Progress count in Step: 0

Step 'DTSStep_DTSDataPumpTask_2' succeeded
Step Execution Started: 1/21/2009 7:43:38 PM
Step Execution Completed: 1/21/2009 7:45:50 PM
Total Step Execution Time: 131.687 seconds
Progress count in Step: 66788

Step 'DTSStep_DTSDataPumpTask_3' failed

Step Error Source: Microsoft OLE DB Provider for ODBC Drivers
Step Error Description:[IBM][iSeries Access ODBC Driver][DB2 UDB]SQL0901 - SQL system error.
Step Error code: 80004005
Step Error Help File:
Step Error Help Context ID:0

Step Execution Started: 1/21/2009 7:43:38 PM
Step Execution Completed: 1/21/2009 7:45:56 PM
Total Step Execution Time: 137.953 seconds
Progress count in Step: 0

Step 'DTSStep_DTSExecuteSQLTask_3' succeeded
Step Execution Started: 1/21/2009 7:43:38 PM
Step Execution Completed: 1/21/2009 7:43:38 PM
Total Step Execution Time: 0.015 seconds
Progress count in Step: 0
****************************************************************************************************

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-01-22 : 01:23:11

Using Google lead me to this
http://publib.boulder.ibm.com/infocenter/systems/scope/i5os/index.jsp?topic=/rzaii/rzaiiodbcsql0901.htm

E 12°55'05.63"
N 56°04'39.26"

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources