This article was previously published under Q219425
This article has been archived. It is offered "as is" and will no longer be updated.
BUG #: 53748 (SQLBUG_70)
When the DTS Export Wizard is used to export a database from SQL Server 7.0 to SQL Server 6.5 and the destination database is created from the Choose A Destination dialog box, the transfer fails and a dialog box titled DTS Wizard Error is displayed with the following message:
Must declare variable @dbpath The size (512) given to the parameter '@dbpath' exceeds the maximum. The largest size allowed is 255.
Data Transformation Services (DTS) incorrectly sends SQL Server 7.0 CREATE DATABASE syntax to SQL Server 6.5.
Before invoking DTS to perform a transfer, create the destination database on SQL Server 6.5 using either of the following:
The SQL Server 6.5 version of SQL Enterprise Manager.
The CREATE DATABASE Transact-SQL DDL statement.
Microsoft has confirmed this to be a problem in SQL Server 7.0. This problem has been corrected in U.S. Service Pack 1 for Microsoft SQL Server 7.0. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
232570INF: How to Obtain Service Pack 1 for Microsoft SQL Server 7.0 and Microsoft Data Engine (MSDE) 1.0
For more information, contact your primary support provider.