Hi many thanks.

I did a lot of test..and i did that.

I WAS ABLE to connect Progress DB in SSIS 2008 r2 using a trial version of PROGRESS DATA DIRECT odbc...

CIAO.

Many thanks for your kind reply.

Yes i did that a week ago.

Yes i downloaded a TRIAL version of DATADIRECT ODBC Driver.

I tested and results were okay even if i encountered...

Ciao.

Many thanks for your reply.

I did what you wrote 2 weeks ago.

But i encountered this error.

TEST CONNECTION FAILED BECAUSE OF AN ERROR IN INITIALIZING PROVIDER

ERROR IM14 MICROSOFT ODBC MANAGER ...The...

Ciao.

I did tests about what you told me...

I installed a Driver ODBC trial version of 15days instead of working with LINKED SERVER object.

I choose DATADIRECT driver.

But i still have problems...

Ciao.

I add also that i am usign linked server and OPENQUERY.

This table is enough big and the query is not so simple...she joins 4-5 tables....

Open Edge 10.2.b has an ODBC...

Hi Many thanks for kind reply.

I tried to use a direct connection but with OPEND EDGE ODBC I was not able.

So i tried with LINKED SERVER.

I am considering to buy...

Ciao my name is Mauro , i write from Italy.

I have today the same problem you posted time ago in this site.

Anyone could help you ???

Did you find a solution...

Hi thanks.

Okay i did as you want.

I confim that you have to use SQL-ODBC PROGRESS EDGE in LINKED SERVER OPEN QUERY statement.

If i understood good, a day i had time...

Thanks too much ....

Quoting name of field as you suggested , i solved my problem.

I have to write a .docx to remeber all particular syntax querying data from an OPENEDGE...

Ciao many thanks for your kind reply.

For this , me too i have the same doubt.

I used also LINKED SERVER but with it , i encountered a syntax problem i...

Many thanks !!!!

I will test all what you wrote.

I will inform you.

Thanks.

Ciao

Now i understood better.

I HAVE to install both OPENEDGE PROGRESS ODBC Driver for 32 and 64 bit ...on my 64 bit windows server 2008.

When i am writing SSIS on Visual...

Ciao.

First of all many thanks for your kind reply.

So if i understood good , i have to deploy my dtsx even if it shwo me that error.

So i shoud have...

Hi my name is Mauro and i am new of SSIS sql server 2008 r2.

I am writing to you because i read you are the only programmer that did a...