Re: Enterprise Manager - Import/Export Data

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Hari Prasad (hari_prasad_k_at_hotmail.com)
Date: 07/22/04 

Date: Thu, 22 Jul 2004 09:23:35 +0530

Hi,

Could you re-register the below DLLS (used by DTS) and try executing
export/import wizard.

Data Transformation Services (DTS)
----------------------------------------------
File Name Description
----------------------------------------------
sqlresld.dll Satellite Resource DLL Loader
dtsffile.dll DTS Flat File OLE DB Provider
dtsffile.rll DTS Resource File
dtspkg.dll DTS Package
dtspkg.rll DTS Resource File
dtspump.dll DTS Datapump
dtspump.rll DTS Resource File
axscphst.dll DTS ActiveX Script Host
axscphst.rll DTS Resource File
dtsrun.exe Command Line Utility to Execute a DTS Package
dtsrun.rll DTS Resource File
sqlunirl.dll SQL Server Unicode/ANSI Translation Layer
custtask.dll DTS Custom Tasks File
custtask.rll DTS Custom Tasks Resource File

Thanks
Hari
MCDBA

"Ross Russell" <RossRussell@discussions.microsoft.com> wrote in message
news:7028A7D7-70E0-486F-9188-2CC6B597F5A4@microsoft.com...
> I created a new database in Enterprise Manager and then attempted to
import data into this new database from an existing database via the "import
data" option. This launches the Data Transformation Services Import/Export
Wizard. I select the data source. I select the destination. I select
'Copy table(s) and view(s) from source database." I select all tables. I
select the 'run immediatedly' option. When I click the 'Finish' button, I
receive the following message in a message box entitled 'Initialize Com:"
>
> Could not create an instance of the DTS Package.
>
> Can anyone tell me what may be wrong? This is SQL Server 2000, SP3.
>

Quantcast