dts that makes updates

hello, its posible that a dts looks the data and compara if the rows
exists in target database make a update of the row and else make a
insert... thanks...
Since DTS has a completely open programming interface, if you can write the
code for it, DTS can do it.
Mike
Mentor
Solid Quality Learning
http://www.solidqualitylearning.com
"hongo32" <hongo32es@.yahoo.com> wrote in message
news:1136565790.166829.213060@.g14g2000cwa.googlegr oups.com...
> hello, its posible that a dts looks the data and compara if the rows
> exists in target database make a update of the row and else make a
> insert... thanks...
>
|||If you have a set of triggers writing to an audit table which DTS uses as a
basis to figure out what has changed, yes.
Otherwise I would look at transactional replication for something like this.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"hongo32" <hongo32es@.yahoo.com> wrote in message
news:1136565790.166829.213060@.g14g2000cwa.googlegr oups.com...
> hello, its posible that a dts looks the data and compara if the rows
> exists in target database make a update of the row and else make a
> insert... thanks...
>
|||Yes, DTS is highly programmable, especially if you script it out to VB. You
can do anything.
But I usually follow a practice of DTSing into a table reserved specifically
for the DTS data, matching the input format, and then I do the moving to
working tables from there. I feel this gives me some advantages:
1) DTS can be programmed, but it is a pain in the butt comparatively.
2) It gives me an exact record of what I received, so I am not wondering
whether an error was because of wrong/incomplete data or a wrong process.
3) It keeps the DTS as simple as possible so you have fewer failures.
4) The update process is clearly separated from the transfer process so it
is easier to debug.
"hongo32" <hongo32es@.yahoo.com> wrote in message
news:1136565790.166829.213060@.g14g2000cwa.googlegr oups.com...
> hello, its posible that a dts looks the data and compara if the rows
> exists in target database make a update of the row and else make a
> insert... thanks...
>
|||Thanks a lot, i am worried because the tables are very big and i don't
wan't translate all the content if i don't need it.
|||If it was me, and it was feasible to do so, I would probably prefer to spend
the money on disk space and do it the way I usually do. I have programmed
DTS a few times and never found it especially enjoyable. It always seemed to
cost more in terms of my time than the extra disk space would be.
But that's just me and my situations. Your mileage may vary.
How much data are we talking about here?
"hongo32" <hongo32es@.yahoo.com> wrote in message
news:1136574548.819640.129250@.g49g2000cwa.googlegr oups.com...
> Thanks a lot, i am worried because the tables are very big and i don't
> wan't translate all the content if i don't need it.
>