|
Home > Archive > MS SQL Data Warehousing > January 2006 > Moving data to data warehouse
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Moving data to data warehouse
|
|
|
| I have data in SQL2000, Access, and MSDE 2000. I am trying to move the data
into a data warehouse (SQL2000). I am thinking of using replication tools to
get the SQL and MSDE data in the warehouse but how do I get the Access data
into the data warehouse? The Access data is limited to the last 60 days and
I would like the warehouse to have all of the data from now on.
Thanks,
--
KC
| |
| Adam Machanic 2006-01-03, 3:23 am |
| Have you looked at writing a DTS package to handle the data load? DTS can
use Access as a source (in addition to SQL Server and MSDE -- you can do it
all via DTS.)
--
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
--
"KC" <KC@discussions.microsoft.com> wrote in message
news:08EDEBDA-A033-4ED3-8720- 43F7167223C8@microso
ft.com...
>I have data in SQL2000, Access, and MSDE 2000. I am trying to move the
>data
> into a data warehouse (SQL2000). I am thinking of using replication tools
> to
> get the SQL and MSDE data in the warehouse but how do I get the Access
> data
> into the data warehouse? The Access data is limited to the last 60 days
> and
> I would like the warehouse to have all of the data from now on.
> Thanks,
> --
> KC
|
|
|
|
|