-
Sybase Connection in SQL 2005 SSIS Project
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
-
Which provider did you use?
-
I used an OLEDB provider. This referenced the datasource name specified in the Sybase ASE Datasource Administrator client utility provided by Sybase.
-
The specific provider for the Sybase connection: ASEOLEDB.1
-
Try create odbc dsn to Sybase then use it as data source.
-
I'll give that a try. Thank you
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|