DSXchange

by using the sort stage and putting the Cluster index column properety then apply the filter or transformer then wil send the first records and filter the duplicated records. This will be useful in the middle of the job.

Hi, I don't know why to specify "before H." you can take the sort satge on column1 and column2 in descndin order. hen you take remove duplicate stage and mention the key column1 and pass the last record( here yu get the oldest date record). Here you have the column 1 - M records also there...

Hi all, Can you help on , how to abort the job in server by using transformer stage or any routine ? my job is multiinstance job and input ODBC stage which called the Stored procedure and return the value 0 or 1 , for value 1 i wanted to abort the job . can you help this requirement. thanks satya