DSXchange

Is the datatype of your target field in Oracle a DATE or is it truly a TIMESTAMP?

So you are wondering if you trim a NULL (an unknown value, btw) that it might turn it into something else and no longer be recognized as a NULL? It won't... and as noted that would be something you could easily test yourself in the time you've spent waiting for a replies. :wink: I'm not familiar wit...

Perhaps you should clarify what "trim the null" means as I have no idea. Regardless, it seems like something you could test easily enough.

Declare the output field as a string and use the DecimalToString() function with an appropriate output mask.

Just wanted to check something... both of quote dsx examples were enclosed with double-quotes, which I removed when I added the code tags that I requested you use. They are not actually part of the files, are they?

I don't believe that an Oracle bulk load (DIRECT=TRUE) will allow you to leverage a sequence during it... but could be wrong. Can you check with your DBA?

So nowadays that's not cron I take it?

Detail for us your entire job design / stages and then also the settings you used in the Pivot stage. I'd also be curious how may nodes you are running on and (if multiple) if it behaves differently if you drop it down from multiple nodes to a single node.

There's no way for us to know what you've done wrong other than to note that has happened somehow... something specifc to the Job Definition section of the dsx has been corrupted. What do you mean by 'changed the job name'? I would guess the problem lies there. If they are small enough, post both yo...

You need to understand the full changes that need to be made, so I'd suggest first exporting a single job that needs the changes. Then do the work via the Designer in that same job and export it again. Compare the two. Take the changes you've identified and use them in your automation effort. Hope y...

OK, I'll bite - why in the world are you doing this by editing the dsx? Why not simply use the Designer client?

What kind of help? What have you tried?

ps. This is a vertical pivot of rows to columns, not columns to rows.

Use the Convert() function to replace that character with an empty string which removes it.

According to whom?

However, I do agree. Rather make sure we solve the whole problem at once rather than a tiny piece of it at a time.