SQL Server Performance

DTC in SSIS

Discussion in 'SQL Server 2005 Integration Services' started by wssaravanan, Jun 22, 2006.

  1. wssaravanan New Member

    I am using SQL server 2000 as the source in loading the tables of the database in the SQL server 2005, this execution needs the parallel execution from the source. When I ran the package of SSIS containing the above task, it gives error like "Cannot enlist in the Distributed transaction". When I tried out the same task in the SQL serve 2005 it's working correctly, the parallel execution doesn't gives me the problem.

    I have assumed that problem is bcoz of DTC in SQL server 2000. Can anyone guide me?


    Thanks in advance,

    Saravnan.W.S


  2. satya Moderator

    Have you checked MSDTC server is started or not on SQL 2000 instance?

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided �AS IS� with no rights for the sake of knowledge sharing.
  3. wssaravanan New Member

    Are You talking about the MSDTC service or server? how can i check the status?

    If that is going to be the service, I can check it from the Administrative Service console
  4. satya Moderator

    It will be installed as a Service (MSDTC) and check from the location you've mentioned.

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided �AS IS� with no rights for the sake of knowledge sharing.

Share This Page