DSXchange

Exactly. This is a classic 'problem' because the command itself is not failing, it ran properly. It has no clue the sqplus session you called within the command failed either as sqlplus itself ran fine. It's just that pesky SQL statement you ran via sqlplus that didn't work quite as well as you hope...

Can you not look up the syntax? Off the top of my head, it would be:

Convert(YourField,@FM,",")

But the arguments might be in the wrong order.

In my humble opinion, you do not want to match the "default date format". Rather, use the TO_DATE() function in your insert SQL, which will always work regardless of default format. TO_DATE(YourColumn,'YYYY-MM-DD') Would work for the "2007-11-08" example posted earlier. The OCI s...

Still not enough information. What format are they listed in your file? What format do you need them in the parameter? You are making us guess, which is never good. Here's mine! You have them in a file like this: 111111 222222 333333 And you need them in the parameter like this: 111111,222222,333333...

Understood. It's just that that is such a buggy version that no-one should still be running it.

Why post this in the TX forum?

Moved to the QS forum as I'm assuming that is the product you are asking about. If not, please clarify.

If by "results are working fine" you mean you know the inserted records are being used by the select, then I suspect the records are rolling back. Perhaps a commit is in order?

There are 'issues' with the Folder stage as it was built for XML processing and passes in the file contents in one lump. You could leverage the Filter option in the Sequential File stage to 'type' those files to standard out using a wildcard pattern.

DSRajesh wrote:I need to pick the all the character before '-' in the string.

Which doesn't match your example and the original question. Did you actually mean after the "_"?

Errr... three pages to get to the fact that you are running an old, unpatched, known to be generally buggy version that you also feel has a known issue with MI jobs? We could have wrapped this up on the first page with that information. Patch. Upgrade. Involve support. Something other than continue ...

That's an option for Parameter Sets. Read about them in the Designer Client Guide pdf, Chapter 5, 'Creating a Parameter Set' section. It is also mentioned in the Parallel Job Tutorial pdf and probably other places as well.

... never mind that you said you need to "disable" them rather than drop them. Not quite the same thing. :wink: Regardless of how you do this, you'd also have to ensure that your connection account has the privleges needed to perform that operation. Typically, one wouldn't. We have a store...

I've been wondering... perhaps we don't understand what "all at once" means. You use Field() to get them one at a time, using that with a proper 4th argument would be the same as simply taking $CommandOutput as a string. I'm guessing that's not really what you want.

How have you been answering this question in all those interviews?

No, you cannot skip tasks unless (as you mentioned) you have enabled checkpoints, you are restarting and those tasks were successful - and then it's automatic. Would be nice if you could simply 'Disable' a task or execute individual tasks ala Informatica but sadly one cannot.