Normally this would be last night but what if you want it to be more
often....have someone tried this - and if so - how ?

a) real time olap
b) be sure to filter records so only new records is being pullled out .. and
scheduling this package more often than once a day .... how often ? per hour
and perhaps even when the user says so in the host system ?

/Michael Vardinghus

Up to date to me means very little latency between the source(s) and the
warehouse

It all comes down to how must time you can afford to leave.

DTS is not good for Realtime
Replication is good for realtime
Rolap is good for realtime.






--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know


"Michael Vardinghus" <michaelvardinghus (AT) hotmail (DOT) com> wrote

Thanks Allan

Can replication only be used between sql servers ? what if host is Oracle ?

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

Host = Oracle = from BOL

Heterogeneous Publishers
SQL Server 2000 can subscribe to snapshot or transactional data replicated
from Oracle, DB2, Access, and other data sources. This allows companies that
are planning to deploy large databases or a data warehouse with SQL Server,
or Internet and intranet applications, to gain access to various sources of
data. That data can then be consolidated in SQL Server 2000 using
replication, and placed into a data mart, data warehouse, or
multidimensional database designed for SQL Server Analysis Services.

To implement snapshot or transactional replication published by
heterogeneous data sources to your SQL Server 2000 applications, configure
SQL Server with third-party software or using applications built with
SQL-DMO and the Replication Distributor Interface.


--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know


"Michael Vardinghus" <michaelvardinghus (AT) hotmail (DOT) com> wrote