Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
gangadhara.ms
Aged Yak Warrior
549 Posts |
 Posted - 2009-12-07 : 04:45:03
|
| Dear All,I am one table in SERVER A with invoice_numbers. I need to lookup for invoice_number in SERVER B with 2 tables and pull back the matched rows back to SERVER A table.I am not able to do any linked server.Please guide me ...Thanks In advance,Gangadhar |
|
|
svicky9
Posting Yak Master
232 Posts |
Posted - 2009-12-14 : 10:13:32
|
| http://msdn.microsoft.com/en-us/library/ms190479.aspxhttp://www.sqlserver007.com |
 |
|
|
JAG7777777
Starting Member
25 Posts |
Posted - 2009-12-17 : 04:34:48
|
| Hi,I would copy the reference tables (server B) to a SQL server DB - and then use these tables in a lookup task within the data flow. This should work fine.Regards,JAG7777777 |
|
|
|
|
|
|
Look up function in SSIS