DSXchange

You already posted this, which I moved to the proper (General) forum:

viewtopic.php?p=389031

Moving this one as well and then locking it.

You could also write your own 'After Job' subroutine that did basically the same check I mentioned earlier and then conditionally called DSSendMail. If you do, make sure you Annotate that on the canvas and (perhaps) set the After Job area to run only if things are ending... gracefully.

Sorry but I can't make any sense out of your question. Can you provide some actual data examples (rather than made up ones) and then the results you need to get from that data? Perhaps then someone can help you get there. Might also help if you exanded on what "multiply the data" means.

Or build a Sequence job. A Routine Activity can check to see if anything was written down the reject link, or a Command Activity can check the size/row count of the file. If a non-zero value is found, the Notification Activity can be triggered to send an email and attach the file as well.

The hashed file was truncated / emptied after the job ran. The 300000 number was the number of successful lookups, so it couldn't have been empty when it ran. And your target number was the number of update operations sent to Oracle, not anything like the number of records updated... keep in mind th...

Google knows.

I'm going to lock this as it is not DataStage related in any fashion. Also please use proper subjects for your posts and I wouldn't include any personal contact information in the body of them either.

Of course it can, as long as you have the proper permissions in place. Check with a SysAdmin to verify along the full path.

Show us what your timestamps look like.

Talk to your DBA and what might have changed or be going on that would cause your listener problem.

Have you verified that you've built a valid path in the routine and your user has the access rights it would need?

If that was true, sure seems like your cut would be working just fine. And I don't see any way that source would get you 1SH no matter how you cut it. :? For grins, what happens if you always assign ScreenOutput<1> to your variables in all three places rather than just the first one? Also, try chang...

By any chance is your Oracle target column a DATE? If so then you don't need to convert it to any particular format, just convert it to a Date.

Show us the full output of the cat/grep/grep command before the cut.

'cat ':TDPATHbin:'/SurrKeyGen_Index_csv | grep -e ':LogSubject:' | grep -e ':NaturalKeyColumnName

That's only going to work if you are generating <= 1 row/second. Why not use a true surrogate instead?

Start date as in the first of the month? Add the missing '01' to your string and then use StringToDate.