Home Forums SQL Server 2012 SQL 2012 - General Importing and exporting SAS files using SSIS. RE: Importing and exporting SAS files using SSIS.

  • 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/