Try
SELECT prod, cono, whse
FROM PUB.icsw

Ross

"Bill Phillips" <BillPhillips@discussions.microsoft.com> wrote in message
news:4BAE2AF1-64E1-464C-83D2-AA8C49CB273B@microsoft.com...
>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,