Running into Windows Error code 2147287038 (Error Source : Microsoft Data Transformation Services (DTS) Package Error Description: The system cannot find the file specified. Or it says, Error: -2147287038 (80030002); Provider Error: 0 (0) Error string: The system cannot find the file specified. Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts.hlp Help context: 713 ) can slow up your day. Searching out this guide will help you take care of the Windows problem once and for all.
The error occurs when using the DTS Package Designer to open Microsft Data Transformation Services (DTS) or when you try to run the DTS package.
Do following to prevent Windows code 2147287038
DTS packages relate to SQL server and the DTS Designer Package is used to create DTS packages of connections, tasks, and workflows for SQL Server 2000. The DTS Designer also allows you to transmit files using File Transfer Protocol and other related tasks. Error code 2147287038 is caused by using the Package Designer for SQL Server 2000 to create and save the package.
To correct the error try using only the tools for SQL Server 2000 to edit the package and run it on the server. If you are using SQL Server 7.0 do not use the tools for this server to edit or run the package designer.
You can also try opening the designer package with Enterprise Manager for SQL Server 2000 and the create a new save with a password for the owner and user.
The problem may also be corrected by downloading and installing Service Pack 3 if you are using SQL Server 7.0 and Data Engine 1.0 which contains the updates necessary for correcting error 2147287038.
TipFor more information, please see: How to fix Windows error #2147287038