"Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message
news:OdqtyclSDHA.1748@TK2MSFTNGP11.phx.gbl...
> OK What you would do is this
>
> Have a trigger on the Source. it logs to a table the
INSERT/UPDATE/DELETE.
> You would generally have a field in there as well as a flag with values of
> U,I,D for obvious reasons. You would then use this to determine through
the
> Data Driven Query Task what to do with the data.
>
>
>
> If there are not too many records in the source it may be quicker to DTS
> over the whole lot
> Then use TSQL to do it
>
> Key in Source not in Dest = INSERT
> Key in DEST not in Source = DELETE
> Key in both = UPDATE
>
> --
>
> ----------------------------
> 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
>
>
>
> "Flo" <Florent.Boulanger@WJMC.org> wrote in message
> news:#PuQz5jSDHA.1556@TK2MSFTNGP10.phx.gbl...
> > I am trying to develop an automatic synchronization between 2 tables and
> run
> > it once a day.
> >
> > The fields of the Source Table are : SSN, first, last, phone,
> email
> > The fields of the Destination Table are : IT_ID, SSN, first, last,
> phone,
> > email (the same 5 fields + a unique ID)
> >
> > During this synchronization, I would like to:
> > a.. delete records in my destination table if they have been deleted
in
> my
> > source table
> > b.. insert records in my destination table if they have been inserted
in
> > my source table
> > c.. update records in my destination table if records are in the
source
> > table
> > I heard that the best way to do it is using Data Driven Task, but I
don't
> > know how to use them for my matter...
> >
> > Any help is welcome,
> > Thank you,
> > Flo
> >
> >
>
>

"Flo" <Florent.Boulanger@WJMC.org> wrote in message
news:#PuQz5jSDHA.1556@TK2MSFTNGP10.phx.gbl...
> I am trying to develop an automatic synchronization between 2 tables and
run
> it once a day.
>
> The fields of the Source Table are : SSN, first, last, phone,
email
> The fields of the Destination Table are : IT_ID, SSN, first, last,
phone,
> email (the same 5 fields + a unique ID)
>
> During this synchronization, I would like to:
> a.. delete records in my destination table if they have been deleted in
my
> source table
> b.. insert records in my destination table if they have been inserted in
> my source table
> c.. update records in my destination table if records are in the source
> table
> I heard that the best way to do it is using Data Driven Task, but I don't
> know how to use them for my matter...
>
> Any help is welcome,
> Thank you,
> Flo
>
>