we had that issue in SQL2005 and Sybase5 before and have never been able to solve it. Now that we upgraded to Sybase10 and SQLServer2008, I hoped we didn't have to trim any single DT_STR-Field we get from Sybase any longer. But it's still the same.
I tried both, the SQLAnywhere ODBC - Driver and the OleDB-Driver. It doesn't matter.
Does anybody know a way to get the DT_STR - Fields from Sybase to SQLServer without having to derive a column and trim the fields?
View Complete Post