DSXchange

Have patience, if someone can they will in due time. For a quicker response, why not take this back to the horse's mouth? Meaning ask IBM or whomever your supplying vendor was.

You can't use the Job Activity stage to do any kind of "in parallel" launches of jobs as it waits for the active job to complete before moving on. You could do so with some other mechanism inside the loop that does not include any "wait" option. However, keep in mind the fact tha...

Which delimiter? Have you tried using the hex value \xED rather than the character itself? Don't recall, you may need to use the Delimiter String property for that.

Wait... are you saying you want to have one process that "sets" the parameters and then another separate process that actually runs the job? If that's the case, you'll need to rethink things as it doesn't work that way. As you've found. Are you using a Job Activity stage to run the jobs or...

We knows. From the original post:

skathaitrooney wrote:According to me due to the 'E' in the expresion, it is considering the number as an exponential form.

It's not about reading, it's about writing and I'll wager that your user doesn't have the permissions needed to write to that directory.

The "double convert" is useful when you want to remove all "bad" characters from a string without specifying them, rather you list the "good" ones to keep. I'm not sure that would be all that helpful here since (as you noted) the Index will work just fine to detect the ...

That last error line seems to be significant...

Right, always good to fully specify what you want and see if it changes the behavior. It would seem you have found a bug, in your shoes I would contact your official support provider.

Are you just using it as the support document notes, to test ODBC connections from the project?

Yeah, as noted that's not a fun one. If you want to try to track it down, do an exact search here for "Fault type is 11" and you'll find 70 posts that mention that, including some from me back in the day I'll wager. See if any of them help. Loop in support as well.

I'm going to go out on a limb here and say that I think they understand the concept of a surrogate key but that their post wasn't worded properly. I think rather than based on two specific columns, they really meant for a grouping of two specific columns - i.e. the business key fields. As in generat...

Server jobs always point at a transformer when they abort as they are the active stage in the job. The first thing you need to do to help debug this is Reset the job and then check the log for a new entry saying "From previous run...". If that appears, post the contents.

Datasets? They are a key parallel framework component so they've been around... forever. I wasn't sure what you meant by you "don't have it yet", guessing that you did not mean the actual stage, yes? If you just meant you haven't used one yet, that's a whole 'nuther kettle of fish and easi...