when i tried to insert data in a table in the remote server it is throwing the following error.
i used transaction in the query.
The operation could not be performed because OLE DB
provider "SQLNCLI" for linked server "server1" was unable to begin a
distributed transaction. - Export Operation Failed
please find me way
thx in advance..
This is not a SQL Server Integration Services issue, so I have moved it to a more appropriate forum. Linked servers are in the are data access/engine not part of the SSIS toolset.
The error seems a bit sparse, I would have expected a bit more about why it cannot create a distributed transaction. Since the distributed transaction appears to be the issue, have you tested this outside of a linked server? There are plenty of KB articles on http://support.microsoft.com that discuss distributed transaction issues, try searching there. I have found the DTCPing, WINRM and DTCTester tools useful for diagnosing such issues, again search the KB or them.
sql
No comments:
Post a Comment