DSXchange

You just need to search here, an exact search for "Link Collector stage does not support" is enough to find your answer.

Welcome! Your process is sound and matches what many people here have implemented, I would wager. There are many ways to skin that particular cat and that's certainly one. A couple of points... I see absolutely no need for a stored procedure, to me that's an unnecessary complication. A routine or ev...

If I had to guess (and I do) I'd say you are looking for a patch.

Do an exact search for DSSEARCH here, I think that will get you on the road to a solution.

I was being somewhat tongue-in-cheek with my answer, just wanted to point out the improper use of the word 'select' rather than insert or update in the DML. I vaguely recall some stage (you've never stated which Oracle stage we're discussing) not having an "update" mode. You could insert o...

Sure... though I'm not cerain how helpful much of it is.

Give something from here a shot, let us know what you tried and what happened. Hopefully you can then come and Resolved the thread.

Nobody gets any training on DS_CONNECT.

From what I recall it is under the "branded_ODBC" directory and comes with a readme that walks you through its use. Poke around, locate it and give it a shot.

I'm assuming that if you run this manually from the command line directly, it doesn't give you that error, yes?

And as we've noted here quite a number of times, a format string that matches the incoming data so it knows how to parse the string.

Or that.

What have you tried? What kind of messages are in your log? StringToDate() should do the trick, one would think.

That's fine, we'll just agree to disagree and see if anyone other than us ever comes back to the thread to continue the conversation.

Sorry but I don't really see where I'm being all that obtuse. Right now we have no idea what the OP thinks is the problem since all they done is state that people don't understand what they are trying to do and simply repeated the issue. So I felt we should address the fundamental issue of reading s...

Let us know what they say. You would be getting a different message if you needed "something extra" installed, this is a fundamental O/S command line message saying it can't find what you want to run.

I don't see how the simplicity of the problem makes partitioning issues go away. If partitioning is not addressed, then the proposed solution will not work. Not at all what I meant, Phil. There's plenty of time to bring partitioning into the picture, all I meant is that I believe we have a fundamen...