I am trying to insert data to tables in remote DB via Linked Server I am getting exception on fetching data from Tables with Xml Column data type on executing below query .
i tried open query as below.
INSERT INTO OPENQUERY([LNK_228], 'SELECT CustomerDetailID, CustomerId, AccountNo, CustomerName, EmailIds, IsActive, IsDeleted, CreatedBy, CreatedDate, ModifiedBy, ModifiedDate FROM [FTS_DIB_ARCH2].dbo.CustomerDetails')
SELECT CustomerDetailID, CustomerId, AccountNo, CustomerName, EmailIds, IsActive, IsDeleted, CreatedBy, CreatedDate, ModifiedBy, ModifiedDate
FROM FTS_DIB_ARCH_TEST.dbo.CustomerDetails
I also tried SELECT * FROM OPENQUERY([LNK_228], 'SELECT EmailIds FROM [FTS_DIB_ARCH2].dbo.CustomerDetails') for which same exception occurs.
Getting exception:Xml data type is not supported in distributed queries. Remote object 'OPENQUERY' has xml column(s).
What I have tried:
i tried open query for table with columns having Xml Column Type as below.
INSERT INTO OPENQUERY([LNK_228], 'SELECT CustomerDetailID, CustomerId, AccountNo, CustomerName, EmailIds, IsActive, IsDeleted, CreatedBy, CreatedDate, ModifiedBy, ModifiedDate FROM [FTS_DIB_ARCH2].dbo.CustomerDetails')
SELECT CustomerDetailID, CustomerId, AccountNo, CustomerName, EmailIds, IsActive, IsDeleted, CreatedBy, CreatedDate, ModifiedBy, ModifiedDate
FROM FTS_DIB_ARCH_TEST.dbo.CustomerDetails
I also tried SELECT * FROM OPENQUERY([LNK_228], 'SELECT EmailIds FROM [FTS_DIB_ARCH2].dbo.CustomerDetails') for which same exception occurs.