Adaptive Server ADO.NET Data Provider Support for SSIS

Adaptive Server ADO.NET Data Provider can be integrated into SQL Server Integration Services (SSIS), allowing for native access to ADO.NET Data Provider functions.

With the integration, you can use Adaptive Server as an:

ADO.NET Connection Manager
ADO.NET Source data flow component
ADO.NET Destination data flow component

The enhanced Adaptive Server ADO.NET Data Provider supports SSIS 2008 and SSIS 2012. The SSIS support relies on the DDEX Provider for Adaptive Server which must be installed before SSIS can be used.

Setting up the Adaptive Server Connection
Configure the Adaptive Server connection.
SSIS Custom Data Flow Destination Component for Faster Data Transfers to Adaptive Server for SQL Server 2008
The Adaptive Server ADO.NET Data Provider distribution includes a SQL Server Integration Services (SSIS) Custom Data Flow Destination component, which performs faster data transfers into Adaptive Server destinations.
SSIS Custom Data Flow Destination Component for Faster Data Transfers to Adaptive Server for SQL Server 2012
The Adaptive Server ADO.NET Data Provider distribution includes a SQL Server Integration Services (SSIS) Custom Data Flow Destination component that is compatible with SQLServer 2012, which performs faster data transfer using bulk-insert protocol into Adaptive Server Enterprise.
Adaptive Server ADO.NET Data Provider Support for SSRS
The Adaptive Server ADO.NET Data Provider distribution includes a Microsoft SQL Server Reporting Services (SSRS) Custom Data Extensions component, which allows users to store credentials in the reporting server.

Parent topic: DDEX Provider for Adaptive Server