Enterprise Manager (Import Data) - DTS Error

You must verify that SQL service is starting with a domain
ID on both SQL Servers and that whatever that Id is, it is
in the local administrators group of both server you are
getting and retriving data from.
Let me know how it goes...
Jay
>--Original Message--
>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.
>.
>Jay,
The two databases are on the same server. One is named TablesSQL and the ot
her is named TablesSQL_empty. Everything works fine except for the import o
r export data functions. I always get the "Cannot create an instance of the
DTS Package" error. It ha
s worked in the past, but I have not used it in quite awhile and now every a
ttempt produces this error.
"Jay" wrote:

> You must verify that SQL service is starting with a domain
> ID on both SQL Servers and that whatever that Id is, it is
> in the local administrators group of both server you are
> getting and retriving data from.
> Let me know how it goes...
> Jay
> 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:"
> 2000, SP3.
>