Install the SDK that includes the Sybase ADO.NET Data Provider.
Add the driver to the global assembly cache (GAC) if you have not yet installed SDK:
AseGacUtility -i Sybase.AdoNet2.AseClient.dll
AseGacUtility4 -i Sybase.AdoNet4.AseClient.dll
Afterwards, run AdoNetRegistrar.
Task
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.
Note:
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.