When I sorting in SSIS using a ORDER BY clause in a OLEDB Source in Oracle 9i, the result differs from sorting in a direct query in Oracle.
I have a OleDB Source with a SQL query in Oracle, with a ORDER BY. The output
IsSorted is set to true, and the column are sorted in the correct order. the order is:
When I execute the query directly in Oracle the order is:
Therefore, the merge join doesn't if I'm joing Oracle and SQL Server. To workaround this problem I put a sort transformation before both dataflows. This workaround was a problem when the datasource had a lot of rows.