DSXchange

Try specifying options -domain -user -password and -server

I suspect it's this one:
drwxrwxrwx 2 dsadm dstage 256 Nov 23 2009 *DataStage*DSA
and that your ls command has truncated the file names (or you have).

Are there any Char data types in the job design?

I don't believe you can make this change at the Excel side. But you *could* make the output of the Transformer Varchar(255) to get the metadata to match.

vishalsongra wrote:what level of audit logging exists for activities performed with the dsadm account in data stage.

None, out of the box. You can always implement some - a "wrapper" of some kind.

Any of the usual mechanisms, such as DataStage export/import or Information Server Manager.

I have nothing to add to what I have already said.

You have a routine activity calling one of your routines DSJobInfo. Whenever a routine returns other than 0 this is regarded - by the "automatically handle" mechanism - as a failure. Either change the routine to return 0 or include an explicit Failure trigger - which takes precedence over ...

Yes, but a Join stage is not the correct stage type. Either a Lookup stage or a Merge stage is needed to get a reject link. That's the point I'm making.

Scroll right in the Columns grid and you will find a property called something like "field contains terminators". Set this to true and your problem will vanish, provided that string fields are all correctly quoted.

Because join's don't have rejects, the Join stage does not support a reject link.

Intelligent Assistants sit in the same location as templates. Sorry I can't remember exact details - I haven't had version 7 for a while.

There is no such thing as a reject from a join - just like in SQL you get the result of the join. Nothing more, nothing less.

Welcome aboard.

It's not worth doing. It already exists. You can use the "Intelligent Assistants" in the product to do this. Once you get to version 8.1.2 you can use FastTrack tool to write jobs to match mapping specifications in a spreadsheet-style environment.