I'm working on a new project trying to test the connectivity between sql server 2008 and SAS.
I'm trying to have a job created in visual studio (VS) to import SAS data to a sql server database. But I have a lot of trouble to configure the odbc connector.
Different drivers are visible in the connection manager : iom data provider, olap data provider 9.1, ole dp for olap provider for sas, local data provider, ...
The problem is when VS asks me to choose a table he gives a really nice error.
the requested collection (tables) is not defined. (system.data) Could not retrieve the table information.
can someone tell me how to retrieve data?
This is not a solution : upload the data from sas to sql server...