SAS Office Analytics, SAS Add-In for Microsoft Office, and other integrations

integration services

Reply
New Contributor
Posts: 3

integration services

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... Smiley Wink

thanks a lot
Super Contributor
Super Contributor
Posts: 3,174

Re: integration services

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
Ask a Question
Discussion stats
  • 1 reply
  • 196 views
  • 0 likes
  • 2 in conversation