February 15, 2013 at 1:59 am
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.
February 15, 2013 at 2:27 am
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.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
February 15, 2013 at 4:27 am
Hi,
we have scenario something like this
mapping table resides in sql server
it have data in mapping table as shown below
codeflag
Ascrapped
Brepaired
Crepaired
Dmodified
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.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply