Integration Serivces x Sybase

Well, I didn't want to say that, but the interaction between integration services and Sybase is not good at all.

The version of my Sybase Database

Adaptive Server Enterprise/12.5.4/EBF 15444 ESD#8/P/ia64/HP-UX B.11.23/ase1254/2105/64-bit/OPT/Mon Mar 24 04:38:00 2008

Example:

When you try to preview a OLEDB Source configured with a Sybase Data Source, the following message appears.

If you try to click OK anyway, you're gonna receive another message

Is there a solution to this problem? No.

Sybase, at least the version I am working with, and when it comes to Data Flow Task, is completely incompatible with SQL Integration Server.

There are other tasks, those who don't need column mapping, that can work with Sybase. But the the great breakthrough of using Integration Services is exactly that, the column mapping to perform transformations without the need of code programming.

Conclusion: the use of Integration Services with Sybase is very limited.

Há!

: (