Friday, February 17, 2012

DTS Import Wizard fails

I am trying to copy updated tables from a DB on a remote SQL server to
my pc using import wizard. I choose "copy objects and data between SQL
Server databases". On the screen "Select objects to copy", all of the
options are unchecked/blank including the script location. Clicking
"select objects" causes the wizard (and enterprise manager) to crash.
An error message refers to mmc.exe. Any ideas?Hi

This sounds like an error with EM itself, is this a one off or re-creatable?
You may want to check that the client tools are up-to-date. To avoid network
problems, it may be easier to restore a backup to a copy database and then
do the updates.

John

"SkyBlue" <aajjww@.postmaster.co.uk> wrote in message
news:60c756c.0407300546.664df6ba@.posting.google.co m...
> I am trying to copy updated tables from a DB on a remote SQL server to
> my pc using import wizard. I choose "copy objects and data between SQL
> Server databases". On the screen "Select objects to copy", all of the
> options are unchecked/blank including the script location. Clicking
> "select objects" causes the wizard (and enterprise manager) to crash.
> An error message refers to mmc.exe. Any ideas?

No comments:

Post a Comment