Configuring the Adaptive Server ADO.NET Destination SSIS Component
The Adaptive Server ADO.NET Destination SSIS component performs faster data transfer
into Adaptive Server destinations.
Copy Sybase.AdoNet4.AseDestination.dll to C:\Program
Files\Microsoft SQL Server\110\DTS\PipelineComponents and
C:\Program Files (x86)\Microsoft SQL
Server\110\DTS\PipelineComponents.
From either of the Microsoft SQL Server directories on your local drive used in
Step 1, register the Sybase.AdoNet4.AseDestination.dll using the
AseGacUtility4.exe provided in the SDK installation.
To launch SQLServer 2012 Data Tools or SQL Server 2012 Data in Windows, select Start > All Programs > Microsoft SQL Server 2012 > SQL Server Data Tools.
Select File > New > Project > Integration Services Project.
The Sybase Destination Component automatically appears in the SSIS
Toolbox.
From the Control Flow Items toolbox drag and drop a Control
Flow object.
Select the Data Flow Destinations tab, then select the
Data Flow Sources Toolbox tab, then drag and drop
Sybase AdoNet4 ASE Destination and ADO NET
Source Component on to the Data Flow tab.
If there is no source or destination connection available in the Connection
Managers window, right-click in the Connection Managers window, and select
New ADO.NET Connection. If there is already an existing
data connection, select it, or click New.
To create a new connection to the destination Adaptive Server, click
New in the Configure ADO.NET Connection Manager window,
then select Sybase Adaptive Server Enterprise Data
Provider.
In the Connection Manager window, enter your connection properties.
To enable bulk insert, in the Additional Connection Props text box, enter:
enablebulkload=1
Note: See AseBulkCopy in the Adaptive Server Enterprise ADO.NET Data Provider
Users Guide for more details about using bulk-insert.
Click OK.
For the ADO.NET source in your data flow, set up the connection and data access
mode. After you connect the data flow path from your ADO.NET source, right-click
Sybase AdoNet4 ASE Destination, and choose Show
Advanced Edit.
From the Connection Manager tab, select the ASE connection
from the Connection Manager field. From the Component
Properties tab, set the TableName property to the destination table
name.
Select the Input Columns tab, and select
Name. This selects all the columns specified by the source
table.
Click OK to establish the connection.
See Microsoft SSIS documentation for more information about data
transfers using SQL Server Integration Services.