December 10, 2008 at 11:15 pm
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.
December 15, 2008 at 9:53 am
How many rows are we talking about? I'd recommend bringing the data across from Oracle to a temp table in SQL Server and then do the comparison with a left join on the temp table.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
December 15, 2008 at 10:54 am
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.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply