DSXchange

What level did you check? There are three places it can be set with each overriding the other - database, session, client - hence the question.

Check the NLS_DATE_FORMAT settings of the two databases.

So, are you saying that the only environment where the jobs will be multi-instance would be test/uat? A little lost here on exactly what you are proposing.

It uses the information in the descriptor to know where all the actual dataset files are located that need deleting.

Please mark your post as Resolved using the button at the top of the page!

Interesting. Could be a bug with the stage.

Are you pointing it to the actual descriptor file (the one that ends with .ds) and the dataset itself? It needs to be the former.

Can you post a representative snippet of the actual XML and your corresponding XPath Expressions? That would help a lot. When you do, let us know which you've marked as the repetition element.

From what I've read here, you really need 8.1.1 for complete istool functionality. And perhaps another patch on top of that, not sure.

No clue about DB2 but importing the table metadata without specifying the "fully qualified" option worked better for me with the Oracle stages. That and I never use the SQL Builder option.

You really should start your own post. Just how "same" is your same issue? Are you on the 7.x release on Windows, for example? Server job?

Making everything multi-instance rather than simply creating a new project per 'environment' is a less than optimal solution. IMHO.

Ernie doesn't need "simple words", he just needs something that illustrates what it is you are trying to do a little better. :!: Why in the world did you feel the need to post your question again? Please delete it before someone replies to it so we can keep a single conversation going. Here.

That's actually the batch file the Notification Stage automatically generates and then deletes afterwards. I'd start with your 'SubMasterLoad' job which is probably a Sequence job. Of course, a direct call DSSendMail would also create it.

Yah! :D

Typically this is an XPath Expressions issue where they don't match the source properly. Can you post some of the gory details of what you are doing, please?