Architects.......

I have tables in a web site database which customers fill their
preferences to receive emails regarding some topics. New customers are
added everyday and existing customer update their profile. I have also
an internal system for internal employees. The table in the website and
the one in the internal system are similar but with minor differences
in their column name (just for general info...this is not my concern at
this time).I am trying to synch this two databases. I want to do an
automatic update from the web db to the internal database. After
importing the tables to the internal system I want to run a stored
procedure which adds/updates new in-house codes (unique to the internal
db) into the imported tables. Update will be done only for those
records which don't match the records in the internal system (i.e.
for those who are new).
Currently I am using a DTS to import data from the web site, T-Sql
query to do matching b/n the web db and add the internal codes to the
imported tables.
But now I want to do it automatically: I know i have a lot of options.
Jobs, DTS with stored procedures ... Can any one suggest a way how to
integrate my options and do it correctly.
Any suggestion would be appreciated
If I need to elaborate the question please email me.
Thanks.>Currently I am using a DTS to import data from the web site, T-Sql
>query to do matching b/n the web db and add the internal codes to the
>imported tables.
>But now I want to do it automatically: I know i have a lot of options.
>Jobs, DTS with stored procedures ... Can any one suggest a way how to
>integrate my options and do it correctly.
First put all the T-SQL into stored procedures. Then, since half the
work is already being done in DTS, it would seem simple enough to
expand the DTS to also execute the T-SQL procs.
Roy