Local Packages Update

[ArizonaRedneck]

Does anyone know how to make a local package that basicaly updates two columns on a local database with ones from a database that's online. I don't want to add rows onto the end (this was all I could seem to get it to do). I want to overwrite the value in a row with the value thats online. The table structure and table name are the same in both places. I'm using sql server 2000. Thanks a lot.

 

[yksvaan]

You are probably meaning dts package, so this should be on DTS forum, but short answer:

There is a Task this can be done with. It is called Data Driven query. It is not self-explanatory (not easy) so take time to study it from documentation.

One of the other possible approaches could be defining the other server as linked server, then you can write sql statements, where you can refer to either of databases in the same statement.

Cheers


[blue]Backup system is as good as the latest recovery[/blue]

 

[ArizonaRedneck]

thanks. that's just what I was looking for. It works great now.