Progress ODBC Connection Problem

I am trying to create an SSIS package. I am using SQL Server 2005 and am
trying to connect to a progress 9.1E db. I have the Datadirect drivers setup
on the SQL server and can connect to the Progress db if I go through
Administrative Tools-ODBC.

I tried creating the import through SMS right clicking the SQL db - Tasks -
Import data. I used the .NET ODBC driver, created the dsn, uid and password
for the connection string. I then click NEXT until I reach the query dialog
box. For testing I am creating a trivially simple query where I am selecting
3 fields from my Progress db. I have tried both of the following queries:

SELECT prod
cono
whse
FROM PUB.icsw


SELECT PUB.icsw.prod
PUB.icsw.cono
PUB.icsw.whse
FROM PUB.icsw

I get the following error for all variations of the query:

SQL Server Inport & Export Wizard
The statement could not be parsed. ERROR [42000] [DataDIrect][ODBC PROGRESS
Driver][PROGRESS]Syntax Error (7587) (PGPRO918.DLL)

I ahve not been able to find any solutions to this problem. Does anyone have
any additional ideas as to why I am getting this error?

Thanks,

Try
SELECT prod, cono, whse
FROM PUB.icsw

Ross

"Bill Phillips" wrote in message

>I am trying to create an SSIS package. I am using SQL Server 2005 and am
> trying to connect to a progress 9.1E db. I have the Datadirect drivers
> setup
> on the SQL server and can connect to the Progress db if I go through
> Administrative Tools-ODBC.
>
> I tried creating the import through SMS right clicking the SQL db -
> Tasks -
> Import data. I used the .NET ODBC driver, created the dsn, uid and
> password
> for the connection string. I then click NEXT until I reach the query
> dialog
> box. For testing I am creating a trivially simple query where I am
> selecting
> 3 fields from my Progress db. I have tried both of the following queries:
>
> SELECT prod
> cono
> whse
> FROM PUB.icsw
>
>
> SELECT PUB.icsw.prod
> PUB.icsw.cono
> PUB.icsw.whse
> FROM PUB.icsw
>
> I get the following error for all variations of the query:
>
> SQL Server Inport & Export Wizard
> The statement could not be parsed. ERROR [42000] [DataDIrect][ODBC
> PROGRESS
> Driver][PROGRESS]Syntax Error (7587) (PGPRO918.DLL)
>
> I ahve not been able to find any solutions to this problem. Does anyone
> have
> any additional ideas as to why I am getting this error?
>
> Thanks,