469,344 Members | 6,393 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,344 developers. It's quick & easy.

SQL Server 2000 to DB2 DTS Package - Permission Denied Error

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.
Sep 20 '07 #1
0 2950

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

reply views Thread by Henrique Berenguel | last post: by
2 posts views Thread by Ross | last post: by
1 post views Thread by Jody Gelowitz | last post: by
10 posts views Thread by MVChauhan | last post: by
1 post views Thread by CARIGAR | last post: by
1 post views Thread by Marylou17 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.