I have a connection to a Sybase database which we stage in a SQL Server 2008R2 database. I can connect the the database and the connection tests out fine. I am using an OLE DB source with a Sybase Driver.
I can even preview data. Note I have shrunk this data set so the data can not be seen but it still demonstrates that the source does return rows.
However when I execute the package it results in failure.
[source 1] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "MyDataSource" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed.
Any ideas as to why this is happening?
UPDATE Adding other error message in spite of them being the opposite of useful. [SSIS.Pipeline] Error: component "source" (1) failed validation and returned error code 0xC020801C. [SSIS.Pipeline] Error: One or more component failed validation. Error: There were errors during task validation.
UPDATE After a few attempts the account sybase account gets locked. Must have something to do with the password.