<div>
<div class="content wysiwyg-content">
I need to read SAS data into SQL Server using SSIS. &nbsp; &nbsp;I am following the &nbsp;example from <br />
<br />
<a href="http://tech.lanesnotes.com/2012/06/importing-sas7bdat-file-into-sql-server.html" rel="ugc">http://tech.lanesnotes.com/2012/06/importing-sas7bdat-file-into-sql-server.html</a><br />
<br />
<br />
I have installed sas.LocalProvider.9.42. I am on Windows 7. &nbsp;I am using SQL Server 2014. &nbsp;I created a connection manager using SAS local data provider 9.4.2<br />
<br />
Test connection succeeds. &nbsp;I create a data flow task and an OLE DB Source. &nbsp;I use my connection manager. &nbsp;I choose Table or View for Data Access Mode. &nbsp;BUT...Name of Table or View shows &quot;No Tables or Views Could Be loaded&quot;. &nbsp;<br />
<br />
What gives? &nbsp;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. &nbsp;In either case I get a successful test connection, but neither choice works. &nbsp;<br />
<br />
I have SAS Enterprise Guide 7.1 installed. &nbsp;I have installed the SAS Universal Viewer<br />
<br />
Thanks!<br />
<br />
Cipriano
</div>
</div>


I need to read SAS data into SQL Server using SSIS.    I am following the  example from 

http://tech.lanesnotes.com/2012/06/importing-sas7bdat-file-into-sql-server.html


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

Thanks!

Cipriano

Trying to read SAS data into SQL Server using SSIS

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

The Statistical Analysis System (SAS) programs consist of two steps, the DATA step and the PROC step. The DATA step reads data and prepares it for use by subsequent DATA or PROC steps. A SAS procedure (PROC) is a collection of statements that execute a certain task. SAS procedures have their own statements and commands, but many are shared among procedures. JMP is the graphical user interface for SAS, and is used in applications such as Six Sigma, quality control and engineering, design of experiments and scientific research.

Statistical Analysis System (SAS)

SQL Server Integration Services (SSIS) is a component of the Microsoft SQL Server database software that can be used to perform a broad range of data migration tasks. SSIS is a platform for data integration and workflow applications. It features a fast and flexible data warehousing tool used for data extraction, transformation, and loading (ETL). The tool may also be used to automate maintenance of SQL Server databases and updates to multidimensional cube data. SSIS replaced Data Transformation Services, which had been a feature of SQL Server since Version 7.0.