By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,300 Members | 1,867 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,300 IT Pros & Developers. It's quick & easy.

SQL Server 2000 to DB2 DTS Package - Permission Denied Error

P: 1
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
Share this question for a faster answer!
Share on Google+

Post your reply

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