Support for Data Transformation Services in SQL Server 2000 64-bit (810927)

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 "Data Migration" 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.