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, 32-bit. 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
Before connecting to the Adaptive Server:
Install the DDEX Provider for Adaptive Server.
Add the driver to the global assembly cache (GAC) if you have not yet installed SDK:
AseGacUtility -i Sybase.AdoNet2.AseClient.dll
Afterwards, run AdoNetRegistrar.
On the Data Flow tab, right click on the ADO NET Source/Destination component you want to configure and select Edit.
Click the New button located next to Connection Manager.
In the Configure ADO.NET Connection Manager window, click New.
Select Sybase Adaptive Server Enterprise Data Provider from the listed providers.
Enter the appropriate connection properties.
To use Adaptive Server ADO.NET with SSIS, set QuotedIdentifier to 1.
Click OK.
By default, an ADO.NET Destination component batches
the insert commands it performs. Currently, performing simple insert
commands are faster than performing batch uploads to Adaptive Server
through SSIS. To set the Destination
component to perform simple insert commands, set the BatchSize property
to 1.
