Article ID: 247750
Article Last Modified on 2/24/2004
APPLIES TO
- Microsoft SQL Server 7.0 Standard Edition
- Microsoft SQL Server 2000 Standard Edition
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.
Additional query words: kbbug oracle
Keywords: kbbug kbpending KB247750