The log shows the following message when trying to transfer rows from MS SQL
SERVER to IBM DB2 OS390.

************************************************** **************************
*************
Execution Started: 11/4/2003 2:49:40 PM

@@LogSourceRows: C:\temp\mssqlgbd2Trace\dtsErroLog2.txt.Source
@@LogDestRows: C:\temp\mssqlgbd2Trace\dtsErroLog2.txt.Dest

@@ErrorRow: 1
Error at Destination for Row number 1. Errors encountered so far in this
task: 1.
Error code: 80004005
@@SourceRow: Logged
@@DestRow: Logged

@@ErrorRow: 2
Error at Destination for Row number 2. Errors encountered so far in this
task: 2.
Error code: 80004005
@@SourceRow: Logged
@@DestRow: Logged

@@ErrorRow: 3
Error at Destination for Row number 3. Errors encountered so far in this
task: 3.
Error code: 80004005
@@SourceRow: Logged
@@DestRow: Logged

@@ExecutionCompleted

Execution Completed: 11/4/2003 2:49:40 PM
************************************************** **************************
*************

I have requested that the existing rows be deleted and there is a (delete
from G40097.CISV11T) sent to DB2.
Next there is a (select * from G40097.CUSV11T) sent to DB2.
This is the last thing sent to DB2.
The DTS execution then terminates with the above error.
Both SQL SERVER and DB2 tables have only one char(30) column.
I am attempting to transfer 3 rows each containing a char(30) column from
SQL SERVER to DB2.

The error 80004005 suggests Access Denied/No Permissions


--
--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"John" <jkeyzer (AT) wpsr (DOT) com> wrote