DSXchange

No problem.

Can you explain what you mean by 'freeware' in your first post? And you mean XP Pro for the client, yes, as DataStage does not support XP Home.

If you have used the Folder stage with one column passing only the filename and then set the XML Input stage to 'URL/Filepath' the issue is not with the Folder stage. Post your question to your Support provider. I think you'll find the issue is your O/S which has... quirks... with XML, including fun...

He expands on his answer, but the bottom line is still 'no'.

Best to stick with English.

'Freeware'? Does that mean that new-fangled 'instant client'?

cosec wrote:Also is there a way to modify the reporting options ?

There is an option to use a 'User defined stylesheet' so the answer to that question seems pretty obvious - depending on what you mean by 'options'. And from what I recall, the default stylesheet is in your Client install directory.

Filter them out post-pivot with a simple "Not(IsNull())" constraint in the transformer after the pivot stage.

arjun_004 wrote:Is there anyway by which we can ensure that whenever files with zero rows are used, the job is run successfully without errors?

Use a Server job.

Yes, just don't expect to be able to 'switch' it. Only the most recently installed version of VC will be usable.

Post your errors. Saying the job "is getting aborted" doesn't help nearly as much as the actual errors. Especially post the log entries that show the end result - the actual command that the job attempted to run.

You're correct - that is technically not correct. It will never be TRUE so it will take the FAL... err the NOT TRUE path.

Because expressions with NULL values always evaluate to FALSE. You need to explicitly test for nulls and handle them accordingly.

A Server lookup does not need a Key field to work, but a hard-coded dummy value will also work.

Start a new post with all of your information in it.

It has been repeatedly advised.