I need to read SAS data into SQL Server using SSIS. I am following the example from
I have installed sas.LocalProvider.9.42. I am on Windows 7. I am using SQL Server 2014. I created a connection manager using SAS local data provider 9.4.2
Test connection succeeds. I create a data flow task and an OLE DB Source. I use my connection manager. I choose Table or View for Data Access Mode. BUT...Name of Table or View shows "No Tables or Views Could Be loaded".
What gives? I have tried setting Server or File Name in the connection manager to C:\Program Files\SASHome\x86, and I've tried C:\Program Files\SASHome. In either case I get a successful test connection, but neither choice works.
I have SAS Enterprise Guide 7.1 installed. I have installed the SAS Universal Viewer