Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
vasu4us
Posting Yak Master
102 Posts |
 Posted - 2008-10-13 : 14:24:03
|
| I have a typical requirement, I have data in oracle server which i need to extract to sql 2000 server using a stored procedure.My question is1.how to grab result data set while running a stored proc(oracle) in ssis using a oracle connection and load a table in sql 2005.2.can i load a table in sql 2000 instead of 2005.I never did something like this, any help is appreciated.Thanks |
|
|
NeilG
Aged Yak Warrior
530 Posts |
Posted - 2008-10-13 : 14:34:02
|
| Yes you can use the odbc source and in the top drop down menu you can select an oracle database |
 |
|
|
vasu4us
Posting Yak Master
102 Posts |
Posted - 2008-10-13 : 14:45:11
|
| I guess you have mistaken,its not in DTSI have to run a stored procedure in SSIS SP has a select statement which grabs data from oracle tableswhich i need to dump in SQL 2000 table.In SSIS Data Flow Source i don't see any option which would run a store proc for me.i can run it in exec sql but how to use the result data? |
|
|
|
vasu4us
Posting Yak Master
102 Posts |
Posted - 2008-10-13 : 15:25:47
|
| OK in the simplest form, someone just tell me if its possible to run a Stored Procedure(oracle) in any of the Data Flow Source Tasks and redirect the result into a SQL 2005 table |
|
|
|
|
|
|
oracle to sql 2000 using ssis