Configure Adaptive Server ADO.NET Destination SSIS component.
- Copy the Sybase.AdoNet2.AseDestination.dll to C:\Program
Files\Microsoft SQL Server\100\DTS\PipelineComponents and
C:\Program Files (x86)\Microsoft SQL
Server\100\DTS\PipelineComponents.
- From any Microsoft SQL Server directory on your local drive, register the
Sybase.AdoNet2.AseDestination.dll assembly using the AseGacUtility
provided in the SDK installation.
- Start SQL Server Business Intelligence Studio.
- On the Toolbox tab, right-click Data Flow Destinations and select Choose Items.
The Choose Toolbox Items window appears.
- Select the SSIS Data Flow Items tab. Click Sybase Adaptive Server Enterprise ADO NET
Destination, then click OK. Select to see the Sybase Adaptive Server ADO NET Destination component.
- To create an SSIS project, select menu. Create or drag and drop a Control Flow object from the Control Flow
Items toolbox.
- From the Data Flow Destinations and Data Flow Sources Toolbox tab, drag and drop
Sybase Adaptive Server ADO NET Destination Component and ADO NET Source Component onto
the Data Flow tab.
- If a source or destination connection is not available in Connection Managers
window, right-click in the Connection Managers window, and select New ADO.NET
Connection. Select the already existing Data connection, or click New.
- To create a new connection to the destination Adaptive Server, click New button in
the Configure ADO.NET Connection Manager window, and 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 utilizing bulk
insert functionality.
- Click OK.
- For the ADO.NET Source in your Data Flow, setup the connection and data access
mode. After you connect the data flow path from your ADO.NET Source, right-click
Sybase Adaptive Server ADO NET Destination Component, and choose Show Advanced Edit.
- From the Connection Manager tab, select 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 the Name check box. This will select all
the columns specified by the source table.
- Click OK.
Note: The SSIS destination component for data transfers from SQL Server 2008 has been
renamed from Sybase.AdaptiveServerAdoNetDestination.dll to
Sybase.AdoNet2.AseDestination.dll.
The connection is established. See Microsoft SSIS documentation for more
information about data transfer.