Kbase P88669: Using Microsoft Data Transformation Services to export data from Progress to SQL Server and receivin
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
8/31/2004 |
|
Status: Unverified
FACT(s) (Environment):
MERANT 3.60 32-BIT Progress SQL-92
SYMPTOM(s):
Using Microsoft Data Transformation Services to export data from Progress to SQL Server
Manually specifying the select statement used within the Microsoft program
Error Source: Microsoft OLE DB Providers for ODBC Drivers
Error Description: [DataDirect-Technologies][ODBC PROGRESS driver][PROGRESS]Syntax error(7587)
Context: Error calling Prepare on the command text
CAUSE:
The manually specified SELECT statement had double quotes around the field names
FIX:
Remove the double quotes from around the field names as the ODBC driver itself, when passing the query in to Progress to execute, will put double quotes around the field names