Good evening to all.
I am new of this forum.
I ha ve a quite good experience in SSIS and SSAS 2008 R2.
My question is about to [b]SSIS in [b]SQL SERVER 2008 R2 and especially is that:
I am not able to add a connection manager in a SSIS.
Clearly i am not able to add a connection manager that connects directly a PROGRESS DB.
In our SQL SERVER server machine, i installed a driver ODBC PROGRESS.
I created also a DSN and this DNS connectioon , was tested okay.
But i cannot understand where to create and how in SSIS...
I have to create an ADO.NET or OLEDB CONNECTION type ???
Has anyone ever used a direct connection to PROGRESS DB ?
I tried in any way but i reached error....
Is it possibile that PROGRESS DB Vendor not compatible with SSIS ???
I tried to connect with my DSN in EXCEL POWERPIVOT or Reporting Services , and I WAS ABLE TO.
I WAS able also to connect with linked server using my DSN,,,,,
(But linked server is little slow and have some limitations to query some features of PROGRESS DB..(extent , name fields with minus and so on).
Why cannot i to create a right connection in SSIS ???
What is it worng with me ???
If anyone can help me with also examples , i will be very happy.
i DO NOT KNOW what kind of connection i ha ve to choose and how to configure.
Many thanks to all.