integration services

[mojerry]

Hi,

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... 😉

thanks a lot

[sbb]

Did a forums search and found this prior thread - suggest you contact SAS Support, open a tracking issue, and get a current reading on available options for your post.

Scott Barry
SBBWorks, Inc.

http://support.sas.com/forums/thread.jspa?messageID=590