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

Anyone use BLAT on SQL2000/W2K3

Has anyone used the Blat application to send emails on SQL Server 2000
running on Windows 2003.
I have used this tool on Windows 2000 successfully - but am encountering
problems on Windows2003 - if anyone can confirm this tool does work OK I'd be
very grateful...
Thanks in advance,
Don't currently have access to one.
insure you have an up to date version of Blat.
You could try scheduling a call to Blat in the task scheduler and check
the error code it returns to the task scheduler log.
you might also try using the -server and -f options instead of the
registered defaults.

Anyone use BLAT on SQL2000/W2K3

Has anyone used the Blat application to send emails on SQL Server 2000
running on Windows 2003.
I have used this tool on Windows 2000 successfully - but am encountering
problems on Windows2003 - if anyone can confirm this tool does work OK I'd be
very grateful...
Thanks in advance,Don't currently have access to one.
insure you have an up to date version of Blat.
You could try scheduling a call to Blat in the task scheduler and check
the error code it returns to the task scheduler log.
you might also try using the -server and -f options instead of the
registered defaults.

Anyone use BLAT on SQL2000/W2K3

Has anyone used the Blat application to send emails on SQL Server 2000
running on Windows 2003.
I have used this tool on Windows 2000 successfully - but am encountering
problems on Windows2003 - if anyone can confirm this tool does work OK I'd b
e
very grateful...
Thanks in advance,Don't currently have access to one.
insure you have an up to date version of Blat.
You could try scheduling a call to Blat in the task scheduler and check
the error code it returns to the task scheduler log.
you might also try using the -server and -f options instead of the
registered defaults.