Article ID: 219425
Article Last Modified on 3/14/2006
APPLIES TO
- Microsoft SQL Server 7.0 Standard Edition
- Microsoft SQL Server 6.5 Standard Edition
This article was previously published under Q219425
BUG #: 53748 (SQLBUG_70)
SYMPTOMS
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:
CAUSE
Data Transformation Services (DTS) incorrectly sends SQL Server 7.0 CREATE DATABASE syntax to SQL Server 6.5.
WORKAROUND
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.
-or-
- The CREATE DATABASE Transact-SQL DDL statement.
STATUS
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.
Keywords: kbbug kbfix KB219425