DSXchange

Hi guys
I am creating a server job, in which taking input from one table and applied sort stage to sort the table with a column and stor the data into other table
job is running fine, but not sorting the table



I used the <column_name> <D>
for order by column name desc.

Please suggest

Thanks
Atul

You should give "Sort criteria, defining which Input Link's Column Names to sort on."

Hi there
this is my sorting criteria. I am taking the input from the user


Please help

Sort probably is working, but the database server for your target table is storing rows in whatever order it feels like. It is a fundamental tenet of databases that storage order is under control only of the database engine.

Atul, try giving like this

You are missing a fundamental point, the one Ray pointed out. To check your sorting, run the output to a flat file - tables have no 'sort' to them. If you want data out in a certain order, use an order by.

yes guys, you are right... I got the sorted data in a flat file
thanks again