SAS Data set into SQL Server 2005

• kumar-378458

  SSChasing Mays

  Points: 636

  More actions

  July 6, 2010 at 10:58 pm

  #145849

  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

• jgillis-854488

  SSC Rookie

  Points: 35

  More actions

  August 16, 2010 at 3:30 pm

  #1207591

  Hi,

  I was curious if you were able to resolve outside this forum; I'm looking for a similar solution.

  Thanks