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

ID: Q247750

The information in this article applies to:

Microsoft SQL Server version 7.0

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 this to be a problem in SQL Server version 7.0.

Additional query words: kbbug oracle

Keywords : kbSQLServ700bug
Version : winnt:7.0
Platform : winnt
Issue type : kbbug