How to resolve the issue that operation could not be performed because ole db provider sqlncli10 for linked server was unable to begin a distributed transaction?

See more:

SQL

How to resolve the issue that  operation could not be performed because ole db provider sqlncli10 for linked server was unable to begin a distributed transaction?

I am using linked server and doing Archival of data from a DB in one server to another DB in another DB Server

The DTC is started/ enabled for the same. But while running the query
to fetch data from a Table in Linked Server Database getting the error as below

operation could not be performed because ole db provider sqlncli10 for linked server was unable to begin a distributed transaction

What I have tried:

DId Archival of data from a DB in one server to another DB in another DB Server
The DTC is started/ enabled for the same
But while running the query

SET XACT_ABORT ON
BEGIN DISTRIBUTED TRANSACTION
Select * from Test.Corporate.dbo.Employee

where Test-Linked Server
Corproate-DB
dbo-Schema
Employee-Table Name