DSXchange

In my current project , we export separate xml file for each changed job and then submit to source control. We write a autobuild script to deploy the changed jobs since last build. But this has be done on Windows for it seems there is no cmd can be used to import xml format in AIX.

Did you try saving the text files as UTF-8 manually and set NLS as UTF on JOB property and set datatype as NvarChar on column definition?

Yes,use varchar instead of decimal on the DB connector stage, will have no leading zero

How are you sorting? Best use a sort stage and explicitly specify "Stable Sort = true" to remove the non-deterministic part of your problem. Since the data A,B,C,1 A,B,D,2 is only sorted on "A" and "B" the record order when not using a stable sort might be different. A...

What's encoding on Oracle side? It may work if you set NLS to UTF-8 and update this field toNvarchar.

I ever also meet the case that it include execution time of after SQL as start up time.

ray.wurlod wrote:Best is to get the provider of the file to give you a correct file. ...

Agree!

I ever avoided the leading zero issue by use VarChar from reading data from DB.

Did you test with setting NLS of JOB to UTF8 and column to Nvarchar (or varChar with Unicode extend)?