Need help: Importing .SAS file to SQL Server 2008 using SSIS

• hydbadrose

  SSCarpal Tunnel

  Points: 4164

  More actions

  October 6, 2011 at 7:24 am

  #260113

  Please help me find the solution to import the .sas dataset to sql server 2008 using SSIS. Is it possible if so then which data provider should I use for .sas dataset?

• steveb.

  SSC-Forever

  Points: 46733

  More actions

  October 6, 2011 at 9:45 am

  #1391282

  Have you tried the SAS OLE db provider.

• COZYROC

  One Orange Chip

  Points: 28499

  More actions

  October 6, 2011 at 10:39 am

  #1391317

  hydbadrose (10/6/2011)

  ---

  Please help me find the solution to import the .sas dataset to sql server 2008 using SSIS. Is it possible if so then which data provider should I use for .sas dataset?

  Check CozyRoc's SAS Data Source component. It is competitively priced and doesn't require installation of SAS products.

  ---
  SSIS Tasks Components Scripts Services | http://www.cozyroc.com/