Webservice vs. traditional bal/dal in windows service vs. ssis

� 

Hi,

� 

Looking for some advice.�  Internally, we will have data coming in that will be parsed, validated and stored in a new sql server 2005 db (let's call it TEMP).�  We then need some kind of processor to periodically check that db for newly inserted data, compare it with existing data in� an existing� sql server 2005 data warehouse db (let's call it WAREHOUSE), analyze the results depending on the use case, and possibly (if it qualifies for it via the use case it fits) put some data in another new db (let's call it WEBDB) that is accessed via an existing asp.net web app that can update this data in that new web db throughout the day, which will nightly push� any updates to it back� into the WAREHOUSE.

� 

My question is this: What is the best way to implement this processor?� 

� 

Should we create a windows service with a tradi ...