Wrox Programmer Forums
SQL Server 2000 General discussion of Microsoft SQL Server -- for topics that don't fit in one of the more specific SQL Server forums. version 2000 only. There's a new forum for SQL Server 2005.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server 2000 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old June 22nd, 2006, 08:10 AM
Registered User
Join Date: Jun 2006
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default DTC in SQL server 2000

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,


Old June 26th, 2006, 08:54 AM
Friend of Wrox
Join Date: May 2006
Posts: 246
Thanks: 0
Thanked 0 Times in 0 Posts

SSIS cannot be run on SQL 2000. And you can't port SSIS to SQL 2000 as a DTC package.

Similar Threads
Thread Thread Starter Forum Replies Last Post
DTC fails to work with SQL Server after changing t titojermaine SQL Server 2005 0 July 24th, 2007 07:24 AM
migrating from sql server 2000 to sql server 2005 abinashpatra SQL Server 2005 2 December 1st, 2006 03:45 PM
SQL Server 2000 and SQL Server 2000 CE dparsons SQL Server 2000 1 July 31st, 2006 12:59 PM
looking for access 2000 to sql server 2000 sql/que method SQL Server 2000 0 July 7th, 2005 12:46 PM
SQL SERVER 2000 AND ACCESS 2000 ckentebe SQL Server 2000 3 June 17th, 2004 08:50 PM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.