Hi All,

  I am trying to design a package that needs to compare two tables in two diiferent servers. Basically I need to insert records into one server by comparing existing records with second table in other server. Is ther any way I can do it with out using Linked server?. Both tables have same structure.

Hope any one will reply soon.

Thanks,

lmp

Report Abuse

Today, 5:41 PM UTC

Eric Wisdahl

Answerer

Posts 591

Re: How to query two tables in two different servers in SSIS

Was this post helpful ?

First off, if you are using either a lookup table or a seperate source it doesn’t matter where your data is coming from… that is the big benifit of SSIS…. Are you just wanting to mirror / replicate your data?  If so, this might not be the best use of ssis as there is already pre-built functionality to do so (I believe anyway).

Here is a link that might help you out if you are looking for ssis info to do this type of operation: http://forums.microsoft.com/IE16/ShowPost.aspx?PostID=1211340&SiteID=1

Bookmark:Digg Del.icio.us Reddit