NEW: Check our new hosted service COZYROC Cloud ...

COZYROC

SQL Server Integration Services (SSIS) components, tasks, scripts and productivity tools.

Products

SSIS+ Components Suite

Comprehensive suite of 200+ components for developing rock solid ETL solutions with Microsoft SQL Server Integration Services.

Learn more

SSIS NoW

Event-based processing using the same SSIS technology we all love.

Learn more

Excel Add-in for SAS

Process SAS system data set files from within Microsoft Excel.

Learn more
Partners
Find a Partner

Become a Partner

Partner Sales Registration
Download
Purchase
PayPal

Purchase Orders
Support
Help Center

Installation and Getting Started

Licensing

Tutorial Videos

Forum

Release Notes
Blog
About Us
About Us

News

Testimonials

Case Studies

Contact Us

SAS Data Destination

Overview
Parameters
Knowledge Base
What's New

Overview

Premium component The SAS Data Destination Component is an SSIS Data Flow Component for loading data into SAS's sas7bdat file. The configuration parameters are provided in the standard data flow destination component dialog.

Parameters

Configuration

Use the parameters below to configure the component.

FILE

Select an existing File connection manager.

Related Topics: File Connection Manager
Input Column Format

Specify result SAS variable format. This property is optional.

Related Topics: Formats Syntax
Input Column Informat

Specify result SAS variable informat. This property is optional.

Related Topics: Informats Syntax

Knowledge Base

Where can I find the documentation for the SAS Data Destination?

What's New

1.8 SR-3

Fixed: Incorrect inclusion of excluded columns in a dynamic data flow.

1.8 SR-1

New: 500% writing performance improvement.

1.6 SR-4

Fixed: Component was not storing date/time column types correctly (Thank you, Steven).
Fixed: Component failed to create files greater than 2GB (Thank you, Javier).

1.5 SR-2

New: Introduced component.

Related documentation

SAS
SAS Data Source

COZYROC SSIS+ Components Suite

COZYROC SSIS+ Components Suite is free for testing in your development environment.

A licensed version can be deployed on-premises, on Azure-SSIS IR and on COZYROC Cloud.

Download Now!

Newsletter

Join VIP subscribers getting Exclusive COZYROC SSIS+ Library updates, private Q&A and more.

Enter your email here: *

No spam, ever. Just great stuff !

Twitter Feed

Connect #Stripe to #SQLServer demo video ⭐Data integration under 7 minutes ⏱️ How to import data from Stripe to SQL… https://t.co/2DT4ZlOewN

How to set up a simple Inbound Webhook that triggers the execution of a package in the #COZYROC #Cloud… https://t.co/EMhzFr5NxH

🔔 Official release of #COZYROC SSIS+ 2.1 version is now public https://t.co/Zf8bSHcVdB ⭐ Support for 31 additional… https://t.co/7I6ToLFQXq

Contact Us

Address: 4350 Lassiter at North Hills Ave, Raleigh, NC 27609, United States
Phone: +1 (919) 249-7421
Support: Help Center

Follow Us

Support

Help Center
Getting Started
Licensing
Tutorials
Forum

Contact
Terms
Privacy

2006-2022 COZYROC LLC ♡ Made with Love