Sybase Connection in SQL 2005 SSIS Project

[trobbins]

Hi,

I've setup an Integration Services project that contains a step to connect to a Sybase ASE server on our network. THe Connection Manger test verifies the connection but when the project is run manually or in debug mode it fails with the following error:

TITLE: Package Validation Error
------------------------------

Package Validation Error

------------------------------
ADDITIONAL INFORMATION:

Error at Package [Connection manager "SYBASE_CONNECTION"]: The connection manager failed to defect from the transaction.

(Microsoft.DataTransformationServices.VsIntegratio n)

------------------------------
BUTTONS:

OK
------------------------------

Any ideas would be welcome. Thx

[rmiao]

Which provider did you use?

[trobbins]

I used an OLEDB provider. This referenced the datasource name specified in the Sybase ASE Datasource Administrator client utility provided by Sybase.

[trobbins]

The specific provider for the Sybase connection: ASEOLEDB.1

[rmiao]

Try create odbc dsn to Sybase then use it as data source.

[trobbins]

I'll give that a try. Thank you