Yes - utilizing DTS to bring in the tables with "delete rows in destination tables"

Annette

-----Original Message-----
From: Javed Iqbal [mailto:javed.[Email address protected]
Sent: Monday, May 30, 2005 6:45 AM
To: Annette Boyd
Subject: Re: DTS-ing tables in


**A LazyDBA.com subscriber has responded to your lazydba.com post**
**LazyDBA.com mail shield has forwarded you this email,
**and removed any attachments, and kept your email address secret
**from this person, and any viruses/trojans.
**If you reply to this email, the person will see your email address as normal
**Anything below this line is the original email text


Are you doing it using DTS?

Regards,
Javed Iqbal
--------------------------------------------------------------------------
Ugam Solutions
C-101 Central Bombay Infotech Park Modern Mills Compound,
K.Khadye Marg, Mahalaxmi,
Mumbai 400011, India
Tel: 91-22-56527300 Ext:410 Fax: 91-22-56527400



----- Original Message -----
From: "Annette Boyd "
[Email address protected]
To: "LazyDBA Discussion" [Email address protected]
Sent: Saturday, May 28, 2005 2:08 AM
Subject: DTS-ing tables in


> Dear Gurus:
>
> Anyone have a suggestion for me?
>
> I have "old backup data" tables on SQL - when I bring tables in, do I have
to remove the relationships from the current tables? I keep getting "PK_FK"
violations because the relationship constraints. But when I remove those -
bring in the data - and then put those back in - it seems to be fine.
>
> Is there a way around it? Or is this just one of those "it works so just
DO it that way" situations?
>
> Annette
>
>
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> Website : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>




MS Sql Server LazyDBA home page