Can we apply a filter and order by for same column in ssis. My condition is: select x.aa, x.bb, x.cc from a x, b y where x.aa= y.bb order by y.bb the data types are same for both. After pulling the data from above query i have to apply a merge join condition using the column y.bb or x.aa with other similar data type. please advice if the above query is correct and show me the possible query if wrong.

Run the query in SSMS and see if you are having any issues in the number of rows. If yes you need to check your condition that you are applying.My Blog | Ask Me | Test your SSIS skills