Board index MS SQL Server

AS400 and Schedules DTS Packages (FYI only)

AS400 and Schedules DTS Packages (FYI only)

Post by RBurk » Fri, 15 Dec 2000 07:00:30



We ran into an issue where the DTS packages extracting data using the Client
Access ODBC driver would not run when scheduled but would when simple
executed.  The usual articles (authority issues) provided no resolution.
What we found was that if the NT profile on the server (which will be used
to attempt the connection) was more than the 10 character profile constraint
on the AS400, the DTS package ends with an unknown error.

Changing the Profile used to sign on to the server to a 10A profile, and
using the same profile (and security) on the AS400 resolved the issue.

 
 
 
Top

1. AS400 - SQL DTS package will not run when scheduled

Very similar to another issue reported.
The DTS package clears a SQL table, links to the AS400 and repopulates the
table in question.
The package runs fine when executed manually and fails when scheduled.
The first part of the job, ie the clearing of the SQL table is executed, so
I believe the problem is not a security problem as the job does start when
scheduled and does what it can.  It seems to be a connection to the AS400
problem, but what is missing?....
Please find below the details provided by SQL on the failed job.

DTSRun:  Executing...   DTSRun OnStart:  DTSStep_DTSExecuteSQLTask_1
DTSRun OnFinish:  DTSStep_DTSExecuteSQLTask_1   DTSRun OnStart:
DTSStep_DTSDataPumpTask_1   DTSRun OnError:  DTSStep_DTSDataPumpTask_1,
Error = -2147008507 (80074005)      Error string:  Unspecified error
Error source:  Microsoft Data Transformation Services (DTS) Package
Help file:  sqldts.hlp      Help context:  1100      Error Detail Records:
Error:  -2147008507 (80074005); Provider Error:  0 (0)      Error string:
Unspecified error         Error source:  Microsoft Data Transformation
Services (DTS) Package      Help file:  sqldts.hlp      Help context:  1100
Error:  -2147467259 (80004005); Provider Error:  5 (5)      Error string:
[IBM][Client Access ODBC Driver (32-bit)][DB2/400 SQL]Communication link
failure. COMM RC=0x5      Error source:  Microsoft OLE DB Provider for ODBC
Drivers      Help file:        Help context:  0      DTSRun OnFinish:
DTSStep_DTS...  Process Exit Code 1.  The step failed.
DTSStep_DTSDataPumpTask_1, Error = -2147008507 (80074005)      Error string:
Unspecified error         Error source:  Microsoft Data Transformation
Services (DTS) Package      Help file:  sqldts.hlp      Help context:  1100
Error Detail Records:      Error:  -2147008507 (80074005); Provider Error:
0 (0)      Error string:  Unspecified error         Error source:  Microsoft
Data Transformation Services (DTS) Package      Help file:  sqldts.hlp
Help context:  1100         Error:  -2147467259 (80004005); Provider Error:
5 (5)      Error string:  [IBM][Client Access ODBC Driver (32-bit)][DB2/400
SQL]Communication link failure. COMM RC=0x5      Error source:  Microsoft
OLE DB Provider for ODBC Drivers      Help file:        Help context:  0
DTSRun OnFinish:  DTSStep_DTS...  Process Exit Code 1.  The step failed.

As mentioned by someone else, I too have error 80004005 with Help context
1100.
It also mentions a Communication link failure COMM RC=0x5, whatever that
means!

Thanking you in advance for your help.

2. Oracle 8 evaluation cd FREE!

3. Scheduling DTS Packages via DTS, SQLDMO COM Object

4. Using database names as variables

5. different behaviour of string concatenation in SQL-server 7.0 com pared to 6.5

6. DTS Package won't schedule / Help with DTS

7. AS400 - Schedule DTS error

8. DTS scheduling with AS400 Data

9. Scheduling DTS AS400 Transfer

10. Run DTS packages from batch file from AS400


All times are UTC
Board index