Thanks a lot, the "" idea worked......

Paul,

In the below insert that we are trying to do:

insert into test@SQLTEST (name, fullname)

values ('Oracle', 'Oracle server data');

- test@sqltest is a table "test" on sql server.

This gives error when...

Paul,

In the below command:

insert into MyLocalTable(name,fullname) select name,fullname from test@SQLTEST

what is MylocalTable? Is this table to be created on Sql server ?

Thanks,

Did you find any solution for this? I too am in need for this solution.

Thanks,