Hi Experts, I am getting below error while running dtctester tool Executed: dtctester DSN: test User Name: ortdbuser Password: xxxxxxxxx tablename= #dtc27690 Creating Temp Table for Testing: #dtc27690 Warning: No Columns in Result Set From Executing: 'create table #dtc27690 (ival int)' Initializing DTC Beginning DTC Transaction BeginTransaction failed: 8004d01c BeginTransaction Call Error: Indicates no longer able to communicate with the transaction manager, because the connection to the transaction manager failed. The transaction was aborted. Help would be appreciated Shashi

Hello, I don't think that you have posted on the good forum. So i propose you that a moderator moves your thread on another forum where your thread should be answered more quickly http://social.msdn.microsoft.com/Forums/en-US/sqltools/threads or http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/threads or http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/threads ( if related to SSIS ) Don't create a new thread on another forum about this problem.One of the most important work of moderators is to move threads from a forum to another one. Post to give your agreement and when the move will be done, you will receive an alert giving you the new link about your thread. Thanks ( it is the best way to avoid to have threads which will never be replied or multiple threads about the same problem on several forums ) The moderators are waiting for your agreement ( in this case, the move will be done ASAP ) Have a nice day Mark Post as helpful if it provides any help.Otherwise,leave it as it is.

Hi, As Papy’s said, your question is more related to SSIS, I recommend that you ask it in SSIS forum, so you can get better answers. Besides, the following link describes your error messages and provides the solution. Please see: http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/thread/bf5f2be9-5907-4522-9579-3a7f8afc9f01 Thanks, Ai-Hua QiuConstant dropping wears away a stone.

Hello, After having read the post from Ai-hua Qiu, i prefer to move your thread in the good forum related to to SSIS and i hope that you will get a full and quick answer. Have a nice dayMark Post as helpful if it provides any help.Otherwise,leave it as it is.

Hello , After i have read the post of Ai-hua Qiu, i will move this thread in the SSIS Forum where, i hope, you will get a full and quick answer. Have a nice dayMark Post as helpful if it provides any help.Otherwise,leave it as it is.

Again its the wrong forum . It should be raised in SQl tools . But still a couple of suggestions 1) check using DTCPING that your able to connect between client and server 2) Check Msdtc settings http://blogs.msdn.com/b/florinlazar/archive/2005/09/16/469064.aspx http://blogs.msdn.com/b/florinlazar/archive/2004/06/18/159127.aspx 3) Last option Unistall and Reinstall MSDTCCheers , Varun

Hi Experts, I feel rather than helping hand everyone wants to throw it in another forum. I have got the fix and it was one of the hotfix which was causing the issue. Warm Regards, Shashi