SSIS Components for Sybase

Build 24.0.9060

Miscellaneous

This section provides a complete list of the Miscellaneous properties you can configure in the connection settings for this provider.


PropertyDescription
EncryptPasswordThis field sets whether password encryption is enabled.
IgnoreGroupNumberWhether to return group number (like ';num') of procedure when list procedures.
MaxRowsLimits the number of rows returned when no aggregation or GROUP BY is used in the query. This takes precedence over LIMIT clauses.
MaxTDSPacketSizeThe protocol sending and receiving buffer size. For the lower version, it's from 512 to 512. For the newer version, it's from 512 to 2048.
OtherThese hidden properties are used only in specific use cases.
QueryPassthroughThis option passes the query to the Sybase server as is.
ReadonlyYou can use this property to enforce read-only access to Sybase from the provider.
RTKThe runtime key used for licensing.
SwitchModeThis property allows you to specify a switching mode to select a server from AlternateServers as the active server.
SwitchStrategyThis property allows you to specify a switching strategy to select a server from AlternateServers as the active server.
TextSizeSELECT statements return text, image, and unitext data up to the limit specified in this property.
TimeoutA timeout for the provider.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060