Pulling data from Oracle Database

Pardon me if this is a stupid question but I am very much a newbie at this
sort of stuff. Is it possible to pull data from an Oracle database and
populate a SQL Server 2000 database. I am not sure if I need some sort of
push\pull subsciption or use DTS. Can someonel please help me by providing
some advise or to point me in the direction to find the answers I am looking
for.
Thank you
Paul
I'm not an Oracle guru, so this is just pointers, as I have it setup.
You need the Oracle client setup on the server, then create a linked server
to the Oracle DB, and do a select into.
There are issue's in translation etc. But I have it working at a basic
level, runs automatically monthly to refresh the SQL Server DW.
KlK, MCSE
"Paul Glickenhaus" wrote:

> Pardon me if this is a stupid question but I am very much a newbie at this
> sort of stuff. Is it possible to pull data from an Oracle database and
> populate a SQL Server 2000 database. I am not sure if I need some sort of
> push\pull subsciption or use DTS. Can someonel please help me by providing
> some advise or to point me in the direction to find the answers I am looking
> for.
> Thank you
> Paul

Pulling data from Oracle Database

Pardon me if this is a stupid question but I am very much a newbie at this
sort of stuff. Is it possible to pull data from an Oracle database and
populate a SQL Server 2000 database. I am not sure if I need some sort of
push\pull subsciption or use DTS. Can someonel please help me by providing
some advise or to point me in the direction to find the answers I am looking
for.
Thank you
PaulI'm not an Oracle guru, so this is just pointers, as I have it setup.
You need the Oracle client setup on the server, then create a linked server
to the Oracle DB, and do a select into.
There are issue's in translation etc. But I have it working at a basic
level, runs automatically monthly to refresh the SQL Server DW.
KlK, MCSE
"Paul Glickenhaus" wrote:
> Pardon me if this is a stupid question but I am very much a newbie at this
> sort of stuff. Is it possible to pull data from an Oracle database and
> populate a SQL Server 2000 database. I am not sure if I need some sort of
> push\pull subsciption or use DTS. Can someonel please help me by providing
> some advise or to point me in the direction to find the answers I am looking
> for.
> Thank you
> Paul

Pulling data from Oracle Database

Pardon me if this is a stupid question but I am very much a newbie at this
sort of stuff. Is it possible to pull data from an Oracle database and
populate a SQL Server 2000 database. I am not sure if I need some sort of
push\pull subsciption or use DTS. Can someonel please help me by providing
some advise or to point me in the direction to find the answers I am looking
for.
Thank you
PaulI'm not an Oracle guru, so this is just pointers, as I have it setup.
You need the Oracle client setup on the server, then create a linked server
to the Oracle DB, and do a select into.
There are issue's in translation etc. But I have it working at a basic
level, runs automatically monthly to refresh the SQL Server DW.
KlK, MCSE
"Paul Glickenhaus" wrote:

> Pardon me if this is a stupid question but I am very much a newbie at this
> sort of stuff. Is it possible to pull data from an Oracle database and
> populate a SQL Server 2000 database. I am not sure if I need some sort of
> push\pull subsciption or use DTS. Can someonel please help me by providin
g
> some advise or to point me in the direction to find the answers I am looki
ng
> for.
> Thank you
> Paul

Pulling Data from more than one UNLINKED table

I am new to this so hopefully you'll bare with me if this is a stupid
question.
I receive data in a dbf format from the state office on a yearly basis. I
have figured out how to use SSIS to pull these into the SQL system as
different tables (e. Birth2002, Birth2003, Birth2004) within a single DB.
The state has a habit of changing the fields names from year to year, and
what I would like to do is build standard queries that compares one year to
the next. Since I cannot link this data (it is prenatal birth data) on any
field because there is no like field from one year to the next, what would a
query look like, say, to compare birth_hospital in 2002, 2003, and 2004.
I have three separate Select statements that pulls and groups the data, but
they are feeding into separate panes (one for each year). How do I get them
in one pane side-by-side?
TIA
Any help is appreciated.SELECT birth_date, birth_hospital
FROM Birth2002
UNION
SELECT BirthDate, BirthHospital
FROM Birth2003
UNION
SELECT Bdte, BHosp
FROM Birth2004
"JC HARRIS" wrote:
> I am new to this so hopefully you'll bare with me if this is a stupid
> question.
> I receive data in a dbf format from the state office on a yearly basis. I
> have figured out how to use SSIS to pull these into the SQL system as
> different tables (e. Birth2002, Birth2003, Birth2004) within a single DB.
> The state has a habit of changing the fields names from year to year, and
> what I would like to do is build standard queries that compares one year to
> the next. Since I cannot link this data (it is prenatal birth data) on any
> field because there is no like field from one year to the next, what would a
> query look like, say, to compare birth_hospital in 2002, 2003, and 2004.
> I have three separate Select statements that pulls and groups the data, but
> they are feeding into separate panes (one for each year). How do I get them
> in one pane side-by-side?
> TIA
> Any help is appreciated.
>
>