DSXchange

Write a routine and use a Case statement maybe

That should not happen. You should be able to see all the function under String. Do you see the same behaviour in your Dev box?

Nop. No rejects from that stage.

For testing purposes, stick a transformer in between the two stages and for the decimal column provide the following derivation

OR


If they dont work, you can also try StringToDecimal().[/code]

Untill "they" add these features, a few work arounds and thoughts: 1. Debugging for PX. Server type debugging. Besides Peek, Head ,Tail, Row, Column gen. There are some bebugging Environment Variables that you can for more debugging options. Refer to Parallel Job Advanced User Guide for more detail...

That didnt help much did it. Open the sequential file and post a few variations of Column D, the decimal column.
Also, what is the design of your job?

The DBA's are never happy to give these rights to anyone Especially if the table names have sys in it Jokes apart, if they understand why the tool requires such access, they will give you access. They just want to be sure on their part that such an access will not in any way harm any thing. Some co...

You can also test it from DSSendMailAttachmentTester() routine under utilities in the Built-In section of Routines folder in your repository.

Reset the job and see if you can accumulate any more messages "from previous run". Post them back here.

These Guys are having fun in that post. It made me laugh. "We're musicians"...

Or just increase the timeout period.

Is LANGU a nullable column. Start investigating from the origin of this colum which might be in a differnt job and handle nulls appropriately.

Ouch. I was ignorant of that fact. I hope I dont bring back stinging memories.

Stored procedures can be called in the before/after sql tab of database stages. If your stored procedure executes once and has no OUT or RETURN parameters then you can live without the STP stage. Else an upgrade is a better way to go. You might also want to look into the ODBC stage. But even that st...

harryhome wrote:Coder for same is out of contact.......

What do you say now harryhome