Reading data from sql in oracle source

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Integration Services » Reading data from sql in oracle source

Reading data from sql in oracle source

Rate Topic

Display Mode

Topic Options

Author

Message

subramani.rudrappa 78855

Posted Friday, February 15, 2013 1:59 AM

SSC Rookie

Group: General Forum Members
Last Login: 2 days ago @ 8:28 AM
Points: 40, Visits: 89

Hi,

i have mapping table which holds codes in Sql and i need to get dat from oracle source based on this codes
please let me know how can we chieve this.

Post #1420430

Phil Parkin

Posted Friday, February 15, 2013 2:27 AM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 10:13 AM
Points: 4,227, Visits: 9,460

subramani.rudrappa 78855 (2/15/2013)

Hi,

i have mapping table which holds codes in Sql and i need to get dat from oracle source based on this codes
please let me know how can we chieve this.

People here are not going to teach you how to use SSIS. But we will help with specifics, if you give us some.

____________________________________________________________________________________________

Help us to help you. For better, quicker and more focused answers to your questions, consider following the advice in this link:

http://www.sqlservercentral.com/articles/Best+Practices/61537/

If you are asking for help and your post does not contain a question, you should expect responses which do not contain any answers. Put a question mark in there somewhere - it's not rocket science.

Post #1420446

subramani.rudrappa 78855

Posted Friday, February 15, 2013 4:27 AM

SSC Rookie

Group: General Forum Members
Last Login: 2 days ago @ 8:28 AM
Points: 40, Visits: 89

Hi,

we have scenario something like this
mapping table resides in sql server
it have data in mapping table as shown below

code flag
A scrapped
B repaired
C repaired
D modified

i have a table in oracle from where i need to extract data based on this codes and this is connected using ADO.net source.
main aim is not to hardcode these mapping values in source as codes will be keep on adding or updating in the mapping table.

our plan is to load these codes in to some temp table of oracle and use it while extracting like
select * from table(oracle ) where code in (select code from mapping table where flag=repaired)

In order to achieve this, we need to extract mapping data from sql and load in to some oracle temp table so that we can achive this.

Post #1420473

« Prev Topic | Next Topic »

Permissions