DSXchange

Wondered if there was some confusion here, hence the question. Unconditional just means the trigger fires no matter what the exit status is.

How are you running the jobs inside the loop? The Job Activity stage will automatically wait so you must be doing something else.

Involve your official support provider, if you haven't already.

Required = mandatory. As noted, the stage will abort the job if the data isn't sorted properly.

Try "007" instead.

Unfortunately, I'm out of town for the week and doing what little I can, posting from my phone. I'm going to have to defer to others to help on this one, I'm afraid.

Details! What exactly do you have in the Execute Command stage? What is your trigger condition between the two stages shown?

The XML Output stage is perfectly capable of writing to multiple files. Dump the Sequential File stage and let the XML Output stage do the writing. Enable the 'Trigger Column' option, this value is monitored and whenever it changes, the current file is closed and a new one is opened so set it accord...

There's at least a couple of ways to do this. First would be more Old School and involves using stage variables to do 'group change detection'. Keep the old value from the previous row and compare it to the current value. Same? Add 1 to your ID. Different? Set your ID to 1. Do an exact search here f...

So... you are trying to convert an 8 digit number into a date? That's far too many steps when it seems like DecimalToDate() will do the trick. And the default format string is "%yyyy%mm%dd" which matched your input so you just need to pass it the decimal value.

It doesn't... both statements are incorrect.

I'd start with this definitely not "weird" issue: Too many open files in system. Translation? You've overloaded the resources configured for your system and it cannot open all of the files it needs to in order to process that many jobs simultaneously. One solution would be to not run them ...

Gotcha.

Play around... try various methods to escape the quotes. Perhaps a backslash, or try wrapping each quote in a pair of quotes.

Why 'user defined'? For a simple insert like that, can you not let the stage generate the SQL, see if it works more better?