Hi I have been working with extracting data from a Progress database (at a client) to include in our BI platform. I have successfully installed an ODBC driver and verified the connection to the external system (odbc -> test connection). The problem is that I am unable to connect to the tables in the database and extract data from inside SSIS. I have added an ADO.Net source and I'm able to successfully test the connection. But when I add a Datareader with a simple SQLcommand (Select <columnname> from <tablename>) I receive an error that the table is unknown. Searching the web I found a few different SQL syntax suggestions. When I try add "PUB.<tablename>" to the string, I receive an insufficient rights error. This leads me to think, that I need to add schema information (not supplied by the client) to the query. But I have no experience with connection to Progress database and I have there been searching for such information without any luck. Can somebody please guide me in the direction of information about how to build the SQLcommand query to connect a Datareader source object with a Progress Database? Thanks in advance!

Have you tried an ADO.Net Source adapter, instead of an ADO Data Reader?Todd C - MSCTS SQL Server 2005 - Please mark posts as answered where appropriate.