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.

1. 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.
2. 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.
3. 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.
4. Select File > New > Project > Integration Services Project.
   The Sybase Destination Component automatically appears in the SSIS Toolbox.
5. From the Control Flow Items toolbox drag and drop a Control Flow object.
6. 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.
7. 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.
8. 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.
9. In the Connection Manager window, enter your connection properties.
10. 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.
11. Click OK.
12. 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.
13. 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.
14. Select the Input Columns tab, and select Name. This selects all the columns specified by the source table.
15. Click OK to establish the connection.
    See Microsoft SSIS documentation for more information about data transfers using SQL Server Integration Services.