https://catalogartifact.azureedge.net/publicartifacts/cozyrocllc1726745399505.sas-7ba0fd0d-ef38-4bde-ac66-475505e3db9e/079de83f-f458-4f27-8c38-eab5a70d97ce_350LogoCOZYROC.png

SAS data - SQL Server Data Integration

par COZYROC

SAS components for Data integration between SAS and SQL Server

SAS - SQL Server data integration by COZYROC is a powerful solution designed to Connect, Import, Export SAS data with SQL Server.

This integration helps businesses streamline their processes, ensuring accurate data flow between the application and MS SQL Server.


SAS SSIS components provide a user-friendly solution for bi-directional data exchange between the application and SQL Server.

The toolkit is easy to use and follows the same guidelines and principles used by the standard out-of-the-SAS SSIS components.


SAS SSIS components for Syncing, Importing and Exporting SAS data:

  • The SAS integration package consists of two parts:

  • SAS Source component - Retrieves data from SAS sas7bdat dataset.

  • SAS Destination component – Inserts data in SAS sas7bdat dataset.

    • Ability to specify input column format and informat.
  • COZYROC Excel Add-In for SAS - The installation will add a new tab into Excel with the title COZYROC

COZYROC SSIS+ Suite is free for download and development within Visual Studio


  • Free developer license. You don't need a license key for testing and development
  • Support for SQL Server 2025 - 2012
  • COZYROC SSIS+ suite includes more than 275 SSIS components and tasks for ETL and Data Integration
  • A licensed version can be deployed on-premises, on Azure-SSIS IR and on COZYROC Cloud

    • Data Flow Task Plus allows creation of Dynamic data flows at runtime and can be used with all COZYROC components.

    This powerful feature requires no programming skills to use and greatly simplifies your maintenance efforts. Check the SSIS Data Flow Task demo video in our Youtube channel


    See also:

Vue d’ensemble

https://catalogartifact.azureedge.net/publicartifacts/cozyrocllc1726745399505.sas-7ba0fd0d-ef38-4bde-ac66-475505e3db9e/ec9220b4-78d7-45b1-a6d0-526cb867c6b0_SASsrc1.png
https://catalogartifact.azureedge.net/publicartifacts/cozyrocllc1726745399505.sas-7ba0fd0d-ef38-4bde-ac66-475505e3db9e/54a9154b-0f47-4009-9af9-07af0ea96293_SASsrc.png