BUG: Table Names Enclosed in Double Quotes When Transferred from SQL Server to Oracle (247750)


The information in this article applies to:

  • Microsoft SQL Server 7.0
  • Microsoft SQL Server 2000 (all editions)
This article was previously published under Q247750
BUG #: 56517 (SQLBUG_70)

SYMPTOMS

When table(s) are transferred from SQL Server 7.0 to Oracle7.x or Oracle 8.x using the Microsoft OLE-DB Provider for Oracle in Data Transformation Services (DTS), they are enclosed in double quotes when created in Oracle.

WORKAROUND

Query the table(s) using quotes in Oracle.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
Modification Type:MajorLast Reviewed:2/24/2004
Keywords:kbBug kbpending KB247750
©2004 Microsoft Corporation. All rights reserved.