Microsoft KB Archive/890841

= FIX: DTS packages fail with an unspecified error on a computer that is running Windows XP Service Pack 2 =

Article ID: 890841

Article Last Modified on 8/29/2007

-

APPLIES TO


 * Microsoft Data Access Components 2.8 Service Pack 1

-





Article contents

 * SYMPTOMS
 * RESOLUTION
 * Hotfix information
 * Prerequisites
 * Restart information
 * Hotfix file information
 * STATUS
 * MORE INFORMATION



SYMPTOMS
After you apply Microsoft Windows XP Service Pack 2, you notice that Data Transformation Services (DTS) packages fail with an unspecified error. This problem occurs when you use Microsoft OLE DB Provider for SQL Server, and the version is 2000.85.1117.0. This version of Microsoft OLE DB Provider for SQL Server is installed by Microsoft Data Access Components 2.8 Service Pack 1 that is included with Windows XP Service Pack 2.

You receive the following error message:

DTSRun OnError: DTSStep_DTSDataPumpTask_1, Error = -2147467259 (80004005)

Error string: Error at Destination for Row number . Errors encountered so far in this task: 1.

Error source: DTS Data Pump

You receive the following error message for error number 2147467259 (80004005):

Error string: Unspecified error

Error source: Microsoft OLE DB Provider for SQL Server

For additional information about the hotfixes that are available for Microsoft Data Access Components 2.8, click the following article number to view the article in the Microsoft Knowledge Base:

839801 FIX: Hotfixes are available for MDAC 2.8

back to the top



RESOLUTION
back to the top

Hotfix information
A supported hotfix is now available from Microsoft. However, this hotfix is intended to correct only the problem that this article describes. Apply this hotfix only to systems that are experiencing this specific problem.

To resolve this problem, submit a request to Microsoft Online Customer Services to obtain the hotfix. To submit an online request to obtain the hotfix, visit the following Microsoft Web site:

http://go.microsoft.com/?linkid=6294451

Note If additional issues occur or any troubleshooting is required, you might have to create a separate service request. The usual support costs will apply to additional support questions and issues that do not qualify for this specific hotfix. To create a separate service request, visit the following Microsoft Web site:

http://support.microsoft.com/contactus/?ws=support

back to the top

Prerequisites
Microsoft Data Access Components 2.8 Service Pack 1

back to the top

Restart information
You do not have to restart your computer after you apply this hotfix.

back to the top

Hotfix file information
The English version of this hotfix has the file attributes (or later file attributes) that are listed in the following table. The dates and times for these files are listed in Coordinated Universal Time (UTC). When you view the file information, it is converted to local time. To find the difference between UTC and local time, use the Time Zone tab in the Date and Time tool in Control Panel.   Date         Time   Version          Size    File name -  16-Dec-2004  05:49  2000.85.1118.0  520,192  Sqloledb.dll back to the top



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the &quot;Applies to&quot; section.

back to the top



MORE INFORMATION
For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

824684 Description of the standard terminology that is used to describe Microsoft software updates

back to the top

Keywords: kberrmsg kbfix kbhotfixserver kbqfe KB890841

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.