DSXchange

Hi Chulett, Thank you for your response. I made it work by creating a routine that counts the records processed by a temporary job of the source file (a job which has an output of a dummy flat file) and put it in a routine activity which makes me run the next job if the record is greater than 0. Tha...

Hi Chulett, Yes, I've already tested it. That's why I'm on a tight spot for it not to happen if it has 0 records to process. i researched further into our forum and saw a post that I can read a hash file for the count using routine, and use it as my basis for condition in Routine Activity via sequen...

Hi chulett, thank you for your response! Yes I already created a separate job to do the count. So it will be a 1 row/1 column data (Count records from the DB). What should I do with USERSTATUS? Put it as an expression in a Nested Condition? I think reading the flat file is better, how should I appro...

Hi All, I have a task that requires me to load data in database if there is a single record (can be count, can be row count), If there is none, the server job will be finished (this is to prevent the target db to be cleared if there are no records found from its source db (Sybase). Can I achieve it ...