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
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 Component dialogs.

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.

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 !

Contact Us

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

Support

Help Center
Getting Started
Licensing
Tutorials
Forum

Contact
Terms
Privacy

2006-2023 COZYROC LLC ♡ Made with Love

SSIS+ Components Suite

SSIS NoW