Hi,

I finally used your method Mark.

I just created the linked server and made a stored procedure which basically contains:

declare @ToLoad table (FileName varchar(10))

insert into @ToLoad

select

 FILEID -- FileName

from

 openQuery(LINKEDSERVER, 'SELECT FILEID FROM "LIBRARY"."LOGTABLE")

Therefore...