Post reply

Two different sources and one destination

  • November 20, 2008 at 9:51 am

    #128833

    I have a scenario for which I want to know the best possible way to extract, transform and load the data.

    There are two servers and two sources: one is a SQL Server table and the other is an Oracle table. Now, both of these source tables have one column name named "IdNo" which is same in both the tables. I mean SQL Server table has a column named "IdNo" and even Oracle table has one column with a similar name.

    Now in both the different tables, the column name having "IdNo" has few "IdNo"'s that are matching, while some are not.

    So, what I have to do is, I have to extract the data from both these tables and then load it into an oracle destination putting the condition that only if the "IdNo" from both of these tables match, then load it into the destination.

    I am having trouble because of the two different data sources.

    I am stuck with this and I want to fix this as soon as I can.

    Any help would be greatly appreciated.

    I am not sure if I need to add a linked server or is there any other way that I can achieve this.

    Thank you.

  • November 20, 2008 at 10:26 am

    #901183

    I have a question for you. When you say you want to load record from 2 data sources to 1 destination, which data source record you want to load? How is exactly this working?

    If you want to get a record from the Oracle source, match against record in the SQL Server data source and then load the record from Oracle data source to the Oracle data destination, simply use the Lookup component using as a source the SQL Server data source.

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply