DSXchange

Try forcing the format of the columns in Excel to be "Text".

As you noted, this has nothing to do with DataStage or ftp and is what Excel does when it sees something that it "knows" is a number, it will convert it including removing any leading zeroes since they're just icky and get in the way.

There's lots of information out there on how to stop it, I know because I've ask the same question of the Internet gods myself in the past. And what you are doing is one of the ways to force Excel to treat the field as text and thus retain the zeroes.

Another is to use an extension other than csv without otherwise changing the file. It can then be imported into Excel (rather the automatically opened by it) and during the import process the User can indicate the field is to be treated as text.

Ray/Chulett

Thank you so much for sharing this information.