Microsoft KB Archive/810927

= Support for Data Transformation Services in SQL Server 2000 64-bit =

Article ID: 810927

Article Last Modified on 1/9/2004

-

APPLIES TO


 * Microsoft SQL Server 2000 64-bit Edition

-



SUMMARY
Data Transformation Services (DTS) components for computers that are running Microsoft SQL Server are not available in SQL Server 2000 64-bit. Note the following changes in functionality:  You can save a DTS package on a computer that is running SQL Server 2000 64-bit and you can run a DTS package against a SQL Server 2000 64-bit dataset, but you must run the package from a computer that is running SQL Server 2000 32-bit and that is set up with SQL Server 2000 tools. If the client installed SQL Server 2000 Service Pack 3 (SP3), the option to schedule the package in SQL Server Enterprise Manager is disabled. If you run the DTS Import/Export Wizard and you decide to save and schedule the package, you receive an error message for the Schedule Package step. If you double-click the Schedule Package step, you receive the following error message:

'Cannot schedule a package on a 64-bit SQL Server'

If the client is running SQL Server 2000 SP2 or earlier, the client can schedule the package by using SQL Server Enterprise Manager or the DTS Import/Export Wizard. However, the package is not successful when it runs as a scheduled job because of the missing DTS components. The Copy Database Wizard cannot run on a computer that is running SQL Server 2000 64-bit or target a computer that is running SQL Server 2000 64-bit. Data migration from SQL Server 2000 to SQL Server 2000 64-bit is supported. You can attach a SQL Server 32-bit database to an instance of SQL Server 64-bit by using either the detach/attach method or the backup/restore method. You can move databases between the 32-bit version and the 64-bit version of SQL Server 2000. For more information, see the &quot;Data Migration&quot; topic in the Microsoft SQL Server 2000 64-bit Readme file. If you use Meta Data Services to store a DTS package, you must manage and store the DTS package on a computer that is running SQL Server 2000 32-bit. Transformable push subscriptions are not supported. Pull subscriptions from a computer that is running SQL Server 2000 32-bit should work with a SQL Server 2000 64-bit Publisher or Distributor.

Keywords: kbinfo KB810927

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.