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.

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 (AT) discussions (DOT) microsoft.com> wrote

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:"

Not all these dlls and rlls need registering.

Have a look here

Redistributing DTS with your program
(http://www.sqldts.com/default.aspx?225)

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know


"Hari Prasad" <hari_prasad_k (AT) hotmail (DOT) com> wrote

Hi Allan,

Just compare the list I provided with SQLDTS.com. Both are the same.

I had a problem few days back and got solved by re-regstering all DLLS which
I took it from redist.txt.

Thanks
Hari
MCDBA







"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

Thanks for the replies. I installed SP3a and the import/export works fine now.

"Ross Russell" wrote: