Reading data from sql in oracle source

  • 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.

  • 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

  • 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