|
|
|
Forum Newbie
Group: General Forum Members
Last Login: Tuesday, June 16, 2009 11:12 AM
Points: 5,
Visits: 34
|
|
I am new to this site so hopefully I am putting this in the appropriate place.
My question is this:
I have a table in sql server that has a varchar field with a corresponding integer field. I need to compare the value in the varchar field to a value in a varchar field in an Oracle linked server database table. If the fields match I need to return the corresponding value that is in the integer field and add it to a sql server table. Thanks in advance to any help on this.
|
|
|
|
|
SSCertifiable
Group: General Forum Members
Last Login: Yesterday @ 10:24 AM
Points: 6,301,
Visits: 5,577
|
|
|
|
|
|
Old Hand
Group: General Forum Members
Last Login: Thursday, July 02, 2009 11:29 AM
Points: 316,
Visits: 569
|
|
| I would think another option might be the use of SSIS. Create two connection managers (one sql and one oracle). Then you can bring in the data sets and lookup/merge/etc using existing components or script components.
|
|
|
|
