Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kumar1248
Starting Member
20 Posts |
 Posted - 2010-07-07 : 00:55:48
|
| Hi Team,I have a SAS data file from a SAS Library and looking for a solution to import to SQL Server 2005. I am thinking of using SSIS for this but had confusion in using which ODBC driver and how to proceed it step by step. When i looked into SAS documentation at http://support.sas.com/documentation/tools/oledb/index.htm i couldnt understand it infact i have confusion with different SAS servers like (what is SAS IOM or SAS/SHARE Data Provider etc...)I have SAS EG + SQL SERVER 2005 + BI Studio in my system. My SAS EG in configured by(Remote system) SAS Server Name, SAS Metadata repository, SAS Library and SAS Data file.SO the problem here is what data provider i have to select to connect to SAS Server on remote machine with these parameters(SERVER NAME,REPOSITORY NAME,LIBRARY NAME,DATA FILE) so that the data copied to SQL SERVER 2005?Is SSIS our solution or any import/export wizard do the job or any other solutions ?Please advice a solution with example.Thanks,JyoKum |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2010-07-07 : 02:59:53
|
| I don't know anything about SAS but if you have a SAS ODBC-driver of some sort on you sql server you can create a System DSN to connect to the sas server, or the other way around with a sql server native client (http://www.microsoft.com/downloads/details.aspx?familyid=d09c1d60-a13c-4479-9b91-9e8b9d835cdc) on your SAS server. Seems like this link provides some information on what you need: http://support.sas.com/techsup/technote/ts626.html- LumbagoMy blog (yes, I have a blog now! just not that much content yet) -> www.thefirstsql.com |
 |
|
|
|
|
|
SAS Data file into SQL Server