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.

Yes this quesry should work.Have you tried this? any issues?My Blog | Ask Me | Test your SSIS skills

yes i have tried it.. its working but my question is whether i can apply the filter and apply order by clause for for sorting using the same column. After the above step is executed well. I am sorting the data to do merge join with a similar data type column and load the data into my target table. The problem is i am short of the rows. There is a difference in expected rows and rows that are coming from the above query.