Re: Missing pri. key, permissions, ID info on export

#1

Make sure you select "Copy objects and data between SQL Server databases" in
the Wizard.

Check what Options are set on "Select Objects to Copy" tab. "Use default
options" appears to cover it, but you can also clear that box and check each
individual option, including "Copy PRIMARY.. keys", "Copy object-level
permissions".

--
Darren Green
http://www.sqldts.com

"Spydrlink" <Spydrlink (AT) discussions (DOT) microsoft.com> wrote

Quote:

We're experiencing an issue that we haven't seen before and we don't know
if it's an SP3a issue or something that we might be doing...or need to do

differently. We're using the DTS Export Wizard to create a package that will
copy over 3 tables from one SQL Server instance to another. In that package
we've specified:

Quote:

- Create the destination table by dropping the existing table and
recreating it from the source.

After we run the wizard, the destination gets dropped, and a new copy of
it is placed. All of the data is getting transfered over. The problem is

that for some reason we're losing our primary keys on the tables, losing the
Unique ID (auto-number) designation, and losing all permissions on the
table. We've checked and double-checked that all that information existing
on our source database and it DOES. But on the destination it DOES
NOT...it's removed.

Quote:

Does anyone know why this would be occurring and if so, how do we go about
fixing it?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Missing pri. key, permissions, ID info on export

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Re: Missing pri. key, permissions, ID info on export - 07-21-2004 , 08:59 AM