Sybase Destination

SQL Server 2005, 2008, 2008R2, 2012, 2014

SQL Server 2005, 2008, 2008R2, 2012, 2014

All Downloads ----- Questions?

Overview

The Sybase Destination Component is an SSIS Data Flow Component, which is used to connect to an Sybase database and to perform bulk loads of data into Sybase tables. The configuration parameters are provided in the standard data flow destination component dialog. This component requires installation of Adaptive Server Enterprise version 15.7.


Demonstration

Setup

Use the parameters below to setup the component.

Parameters

IDbConnection

Select an existing ADO.NET Sybase Adaptive Server Enterprise Data Provider connection manager, or click <New connection...> to create a new connection manager.

The Sybase data provider supports multiple bulk-load modes. To set the bulk-load mode you have to include ENABLEBULKLOAD parameter in your connection string and use one of the options below:

Option Description
0 Bulk-mode is not used (default).
1 Enables bulk-load using array insert.
2 Enables bulk-load using the bulk copy interface.
3 Enables bulk-load using the fast logged bulk copy interface.

Related Topics: ADO.NET Connection Manager

DestinationTable

Specify the destination database table where the data is to be loaded.

BatchSize

Specify the number of rows to be sent as a batch.

Timeout

Specify the number of seconds allowed for the bulk copy operation to complete before it is aborted.

How to modify the destination table dynamically at runtime?

The destination table is available in the data flow properties list. Follow these steps to set up an expression:

  • Right-click on the data flow canvas and select the Properties menu.
  • Scroll down and find the property named like [Sybase Destination].[DestinationTable]. This is the property containing the destination table.
  • Scroll down and find the Expressions property. Set up an expression to modify the statement dynamically.

Samples

  • To test the performance of the Sybase Destination component against the standard ODBC Destination, see this package. You must create a TEST_TABLE table with the following columns:
    • COL1 INT
    • COL2 DATETIME
    • COL3 FLOAT
    • COL4 NVARCHAR (255)
    • COL5 NVARCHAR (255)

    The NumberOfRows variable controls the number of rows inserted.