SSIS Components for SASDataSets

Build 21.0.7940

Establishing a Connection

Connecting with the SAS Data Sets Connection Manager

Adding a new SAS Data Sets connection to the SSIS package is straightforward. Right-click within the Connection Manager window and select New Connection from the menu. Then, choose the SAS Data Sets Connection Manager from the Add SSIS Connection Manager window.

Alternatively, you can create a new connection directly using the SAS Data Sets Source or the SAS Data Sets Destination. You can set the connection properties in the SAS Data Sets Connection Manager window.

Connecting to SAS Data Sets

Set the following connection properties to connect to your SAS Data Sets files:

  • URI: Set this to the folder containing your .sas7bdat resources. Currently we only support local files.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7940