473,703 Members | 2,341 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

SQL Server 2000 to DB2 DTS Package - Permission Denied Error

1 New Member
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-CopyQualDatatoD B2-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_DTSExe cuteSQLTask_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_DTSDat aPumpTask_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_LICEN SE', 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.h lp
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 3203

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

Similar topics

by: Jay Chan | last post by:
We have just installed a SQL Server 2000 (SP 3A) onto a computer that has Windows-2003 Server on it. Now, we cannot get access to that database server from other computers. Seem like this may be an issue with Active Directory. Our network consists of Windows-2000 Servers (SP 4) and Windows-2000 workstations and Windows-XP workstations. We also have SQL Server 2000 (SP2) in three Windows-2000 servers. All work fine. Recently, we get a...
by: grondaia | last post by:
Here's my situation: I have an ODBC DSN setup for Timberline Data (An accounting package that uses pervasive.sql) on my sql box. I set up a linked server using the supplied timberline odbc driver. I have two sql instances setup, the default instance and a named instance. On the default instance, the linked server works great no matter who is logged in using it (all authentication is NT integrated). However on the named instance only...
by: Michael | last post by:
I am using MS Access 2000 on an Windows XP machine and am trying to use the Upsizing Tool in Access 2000 to upsize an Access 2000 database to use with Microsoft SQL Server 7.0. My MS Access 2000 version is part of an Office 2000 Developer Edition upgrade from Office 97. Included in the Office 2000 SR-1 Developer package is a disk entitled Microsoft SQL Server 7.0 that I have installed.
by: Henrique Berenguel | last post by:
Hello folks. How do I solve the problem below? when my program executes the line below : Package.WriteXml(Server.MapPath(strID + ".XML")); Ireceive the following error message: System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.UnauthorizedAccessException: Access to the path
by: Ross | last post by:
Hi I have an application using asp.net that I am running on my PC. The web form has a text box where you can enter a name for a new Photo category then click on the button. The code is intended to create a new directory under Photos such as "Relatives".
by: Jody Gelowitz | last post by:
We are having an issue in that when trying to read a file that is on Server2 from Server1 (through our ASP.NET project), we receive the error: Access to the path "\\Server2\MyShare\MyFile.tif" is denied. Here is the server setup that we have: Dev - Development Computer on WinXP Pro SP2 (IIS5), VS2003 developing under .NET Framework 1.1 Server1 - Web Server on Win2003 Server (IIS6) Server2 - File Server on Win2003 Server
by: MVChauhan | last post by:
Hi We are planning to move over to SQL Server 2005 in near future. At the moment Website is on a seperate server then the Database. OS for both the server is Window 2003 and currently our data is on SQL Server 2000(on which everything works fine). Part of the testing process we tried to connect our website on SQL 2005 and it does not work at all.
by: Jobs | last post by:
Download the JAVA , .NET and SQL Server interview with answers Download the JAVA , .NET and SQL Server interview sheet and rate yourself. This will help you judge yourself are you really worth of attending interviews. If you own a company best way to judge if the candidate is worth of it. http://www.questpond.com/InterviewRatingSheet.zip
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.