Hello All,

I've been a member of Webdeveloper.com, but I'm finding more and more of my solutions coming from this community, so here I am!

I'm currently looking for a way to import data from a remote database into my SQL 2005 DB. Here is the scenario: I have a DB with tables X, Y, and Z. Within tables X and Y, there are some fields which I want to populate from a remote database that already contains data for those fields.

Here's some kickers - I need the information to remain current at all times in my DB. Thus, doing manual dumps from the remote database and then importing manually is not ideal.

I have looked into Linked Servers, but this feature is somewhat different than what I need. I cannot obtain write access to the remote database. I only need to bring in the data. I do not need to manipulate it. If Linked Databases can accomplish this for me, please let me know, but I'm currently under the impression that it requires RW access.

Thanks for any help!