Importing and exporting SAS files using SSIS.

• Timothy P.Commo

  SSC-Addicted

  Points: 412

  More actions

  February 2, 2018 at 12:32 pm

  #329072

  I have been asked to research how SSIS can be used for importing and exporting SAS data. I have no familiarity with SAS.
  My question is can SAS code be embedded in transformations in an SSIS package?

  Thanks!

  Tim C.

• subramaniam.chandrasekar

  SSCarpal Tunnel

  Points: 4223

  More actions

  February 5, 2018 at 12:39 am

  #1978504

  Timothy P.Commo - Friday, February 2, 2018 12:32 PM

  I have been asked to research how SSIS can be used for importing and exporting SAS data. I have no familiarity with SAS.
  My question is can SAS code be embedded in transformations in an SSIS package?

  Thanks!

  Tim C.

  I  haven't implemented the SAS import / export from my end, But I can tell you that this SAS load will be same as others. If you could take a look at the below,

  https://sqlserverjedi.wordpress.com/2012/02/08/loading-sas-files-with-ssis/