Home Forums SQL Server 2005 SQL Server 2005 Integration Services multiple server Query without linked server RE: multiple server Query without linked server
Tommy Bollhofer
SSChampion
Points: 14940
More actions
February 13, 2008 at 10:19 am
#777946
How about using OPENROWSET?
OPENROWSET ( 'provider_name'
, { 'datasource' ; 'user_id' ; 'password'
| 'provider_string' }
, { [ catalog. ] [ schema. ] object
| 'query' }
)
Tommy