Hi all

i want to copy a set of tables from one database to another. Say i have two
tables products and categories. products is referring to categories through a
foreign key. i want to copy only products to another databse. i want to copy
the products table along with the primary key and not with the foreign key.
how to do that using dts

You could use the copy SQL Server objects task. Make sure on the options button down the button then you ask to take constraints
etc.

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - SQL Server 2005 Integration Services.
www.Konesans.com


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

Hi allen.

I think you are talking about the "copy primary key and foreign key " check
box in the options button. I knoe that. But the problem is it will copy both
the primary key and foreign key . i want to copy only the primary key not the
foreign key as i am not copying the parent table.

"Allan Mitchell" wrote:

Then you will need to script things out and apply the constraints post exporting the data. As you can see the options in this task
are not flexible enough for your needs.

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - SQL Server 2005 Integration Services.
www.Konesans.com


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