How to Append new rows and update existing rows using dts

Hello,
I'm trying to create a DTS package that allows me to update a new
database for a new site with the rows from the old site's database. I
know how to get the data to the new database, transformed how I want,
and I know how to append rows, but I have not been able to figure out
how to do updates to rows. I want to create a package that inserts new
rows and updates any changes made to old rows.
Ideally if there was a way to somehow link data from the old database
to the new database so that the two were kept syncronous on a real time
basis that woudl be ideal.
Any ideas or suggestions?
Thanks,
Jeff
Hi
If you use Execute SQL Task object you can write T-SQL query to handle those
changes
<jefftim@.gmail.com> wrote in message
news:1162916174.330520.50970@.e3g2000cwe.googlegrou ps.com...
> Hello,
> I'm trying to create a DTS package that allows me to update a new
> database for a new site with the rows from the old site's database. I
> know how to get the data to the new database, transformed how I want,
> and I know how to append rows, but I have not been able to figure out
> how to do updates to rows. I want to create a package that inserts new
> rows and updates any changes made to old rows.
> Ideally if there was a way to somehow link data from the old database
> to the new database so that the two were kept syncronous on a real time
> basis that woudl be ideal.
> Any ideas or suggestions?
> Thanks,
> Jeff
>
sql

How to Append new rows and update existing rows using dts

Hello,
I'm trying to create a DTS package that allows me to update a new
database for a new site with the rows from the old site's database. I
know how to get the data to the new database, transformed how I want,
and I know how to append rows, but I have not been able to figure out
how to do updates to rows. I want to create a package that inserts new
rows and updates any changes made to old rows.
Ideally if there was a way to somehow link data from the old database
to the new database so that the two were kept syncronous on a real time
basis that woudl be ideal.
Any ideas or suggestions?
Thanks,
JeffHi
If you use Execute SQL Task object you can write T-SQL query to handle those
changes
<jefftim@.gmail.com> wrote in message
news:1162916174.330520.50970@.e3g2000cwe.googlegroups.com...
> Hello,
> I'm trying to create a DTS package that allows me to update a new
> database for a new site with the rows from the old site's database. I
> know how to get the data to the new database, transformed how I want,
> and I know how to append rows, but I have not been able to figure out
> how to do updates to rows. I want to create a package that inserts new
> rows and updates any changes made to old rows.
> Ideally if there was a way to somehow link data from the old database
> to the new database so that the two were kept syncronous on a real time
> basis that woudl be ideal.
> Any ideas or suggestions?
> Thanks,
> Jeff
>

How to Append new rows and update existing rows using dts

Hello,
I'm trying to create a DTS package that allows me to update a new
database for a new site with the rows from the old site's database. I
know how to get the data to the new database, transformed how I want,
and I know how to append rows, but I have not been able to figure out
how to do updates to rows. I want to create a package that inserts new
rows and updates any changes made to old rows.
Ideally if there was a way to somehow link data from the old database
to the new database so that the two were kept syncronous on a real time
basis that woudl be ideal.
Any ideas or suggestions?
Thanks,
JeffHi
If you use Execute SQL Task object you can write T-SQL query to handle those
changes
<jefftim@.gmail.com> wrote in message
news:1162916174.330520.50970@.e3g2000cwe.googlegroups.com...
> Hello,
> I'm trying to create a DTS package that allows me to update a new
> database for a new site with the rows from the old site's database. I
> know how to get the data to the new database, transformed how I want,
> and I know how to append rows, but I have not been able to figure out
> how to do updates to rows. I want to create a package that inserts new
> rows and updates any changes made to old rows.
> Ideally if there was a way to somehow link data from the old database
> to the new database so that the two were kept syncronous on a real time
> basis that woudl be ideal.
> Any ideas or suggestions?
> Thanks,
> Jeff
>