"Hari Prasad" <hari_prasad_k@hotmail.com> wrote in message
news:%234Phz%235bEHA.212@TK2MSFTNGP12.phx.gbl...
> 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.
> >
>
>

"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

>
> Could not create an instance of the DTS Package.
>
> Can anyone tell me what may be wrong? This is SQL Server 2000, SP3.
>

"Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message
news:uvQT1r6bEHA.2816@TK2MSFTNGP11.phx.gbl...
> 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@hotmail.com> wrote in message
> news:%234Phz%235bEHA.212@TK2MSFTNGP12.phx.gbl...
> > 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.
> > >
> >
> >
>
>

"Ross Russell" wrote:

> 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.