Design Problem

Hi Gurus
I have seen a desing like this. I found the following problems(?) but I want
comments of Gurus
1)There are four sourse databases(all sql server) and that data is staged
using .exe into another database in another location. This .exe runs windows
bach and inserts data at particular intervels. this data is again marshelled
in to denormalized table from where Notifications are released at different
intervels.
2) the .exe file actullay uses a table in the destination database where all
parameters and related queries are stored to fetch data from source database
s.
Your help is solicited on the following
1) whether .exe is better than sql job with linked server method for
fetching data.
2) Is is right way to store queries in a table than using stored procedure
for that.
can any one tell me pros and cons of both models
--
Thanks in Advance
Regards
SuparichituduWhy not look at DTS? Since you are transferring data between tables and
there is also a step of writing data into de-normalized tables, DTS would
prove quite useful.
--
HTH,
SriSamp
Email: srisamp@.gmail.com
Blog: http://blogs.sqlxml.org/srinivassampath
URL: http://www32.brinkster.com/srisamp
"Suparichithudu" <Suparichithudu@.discussions.microsoft.com> wrote in message
news:94BC6416-21E5-4FEA-B521-6CC19ABCFDA3@.microsoft.com...
> Hi Gurus
> I have seen a desing like this. I found the following problems(?) but I
> want
> comments of Gurus
> 1)There are four sourse databases(all sql server) and that data is staged
> using .exe into another database in another location. This .exe runs
> windows
> bach and inserts data at particular intervels. this data is again
> marshelled
> in to denormalized table from where Notifications are released at
> different
> intervels.
> 2) the .exe file actullay uses a table in the destination database where
> all
> parameters and related queries are stored to fetch data from source
> databases.
> Your help is solicited on the following
> 1) whether .exe is better than sql job with linked server method for
> fetching data.
> 2) Is is right way to store queries in a table than using stored procedure
> for that.
> can any one tell me pros and cons of both models
> --
> Thanks in Advance
> Regards
> Suparichitudu
>