Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Reading data from sql in oracle source Expand / Collapse
Author
Message
Posted Friday, February 15, 2013 1:59 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, July 3, 2014 5:09 AM
Points: 45, Visits: 111
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
Posted Friday, February 15, 2013 2:27 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 4:18 AM
Points: 5,245, Visits: 12,161
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.

When you ask a question (and please do ask a question: "My T-SQL does not work" just doesn't cut it), please provide enough information for us to understand its context.
Post #1420446
Posted Friday, February 15, 2013 4:27 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, July 3, 2014 5:09 AM
Points: 45, Visits: 111
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 »

Add to briefcase

Permissions Expand / Collapse