I am executing a DTS package on a Windows 2000 sp4 server running SQL Server 2000 and IBM DB2 V7 client. The DTS package source data(SQL Server) is selected from SQL server table and inserts data to the destination table(DB2). I get the following error when the package is executed:
The execution of the following DTS Package succeeded:
Package Name: PEX2-CopyQualDatatoDB2-UAT
Package Description: (null)
Package ID: {949FE531-E9D5-432A-ACC6-2C4E0758AB10}
Package Version: {08232EB3-8073-473E-B745-2E9FBF97957F}
Package Execution Lineage: {492763BD-7C8D-4D87-A121-30714ACE211E}
Executed On: N2KSQLDEV01
Executed By: SVCSQL
Execution Started: 09/13/2007 10:07:04 AM
Execution Completed: 09/13/2007 10:07:41 AM
Total Execution Time: 36.579 seconds
Package Steps execution information:
Step 'DTSStep_DTSExecuteSQLTask_1' succeeded
Step Execution Started: 09/13/2007 10:07:04 AM
Step Execution Completed: 09/13/2007 10:07:05 AM
Total Step Execution Time: 0.672 seconds
Progress count in Step: 0
Step 'DTSStep_DTSDataPumpTask_1' failed
Step Error Source: Microsoft Data Transformation Services (DTS) Data Pump
Step Error Description:The number of failing rows exceeds the maximum specified.
(Microsoft Data Transformation Services (DTS) Data Pump (80040e21): Insert error, column 6 ('R_RATE_MM', DBTYPE_NUMERIC), status 9: Permission denied.)
(Microsoft Data Transformation Services (DTS) Data Pump (80040e21): Insert error, column 5 ('C_QUARTER', DBTYPE_STR), status 9: Permission denied.) (Microsoft Data Transformation Services (DTS) Data Pump (80040e21): Insert error, column 4 ('D_RESULT', DBTYPE_DBDATE), status 9: Permission denied.)
(Microsoft Data Transformation Services (DTS) Data Pump (80040e21): Insert error, column 3 ('C_QUALITY', DBTYPE_I2), status 9: Permission denied.) (Microsoft Data Transformation Services (DTS) Data Pump (80040e21): Insert error, column 2 ('I_LICENSE', DBTYPE_STR), status 9: Permission denied.) (Microsoft Data Transformation Services (DTS) Data Pump (80040e21): Insert error, column 1 ('C_STATE_LICENSE', DBTYPE_STR), status 9: Permission denied.)
(Microsoft OLE DB Provider for ODBC Drivers (80040e21): Multiple-step OLE DB operation generated errors.
Check each OLE DB status value, if available. No work was done.)
Step Error code: 8004206A
Step Error Help File:sqldts80.hlp
Step Error Help Context ID:0
Step Execution Started: 09/13/2007 10:07:05 AM
Step Execution Completed: 09/13/2007 10:07:40 AM
Total Step Execution Time: 35.735 seconds
Progress count in Step: 0
Any advise on how to get around this issue would be greatly appreciated.