I have a table that I empty then re-import with a scheduled DTS package.
What is the best way to designate a column as a primary key within the
package details. Would it be possible to create a new column and make it
a PK within the package? Help appreciated. Thanks.

Frank


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Yes. Anything you can do like that in TSQL you can do in a DTS Package.

If you export the table you can then have an ExecuteSQL task that makes a
column the Primary Key afterwards.

If you are only emptying the table then why would you drop this constraint
each time ?
--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org



"Frank Py" <fpy (AT) proactnet (DOT) com> wrote

Thanks, I have been working with this. How would I create a primary key
on a column or a composit primary key on 2 columns if the table and data
is already created by DTS. I know you mentioned SQL task, but I was
having trouble finding a syntax example that didn't have CREATE TABLE
with it. Is this possible? Thanks.
Frank



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Woops! Sorry, I was making this too hard. I just created the keys in
Enterprise Manager and it works fine each time the data is reloaded with
DTS. Thanks again.
Frank



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!