DSXchange

Row Number Column? Not aware of that particular functionality.

Welcome aboard. :D As noted, there's no direct 'sort unique' functionality in the Sort stage. However, you can leverage the Sort stage to identify and eliminate duplicates in a trailing Transformer using stage variables. There are other techniques as well, the Filter option in the Sequential File st...

You are asking IBM these same questions, yes?

Yup, just make sure you OUTER in the right direction.

ps. That's not a 'cartesian product'.

True... but now it's "out out" and it still hasn't been added. Perhaps I should have said it's "past time".

You might also want to specify what the actual problems are that you are having. Let us know what you've tried and if it "didn't work" tell us why. This helps us focus on solutions rather than shooting in the dark or repeating things you've already tried.

What are the requirements for a 'SmallDateTime'? Meaning what does the data look like or need to look like? I'm familiar with the Oracle bits, but not SQL Server.

Also take a moment and Search the forums for 'smalldatetime' as I'm sure this (in some context) has been discussed before.

Yup. My goal in this thread was to eliminate the Oracle 'truncated data' message which seems to have happened. Not really a SQL Server guy, so hoping others will help on that front.

ODBC is being used on the target side for SQL Server, I don't believe the OP has explicitly stated the stage used for the source. Sure sounds like an OCI stage, however.

Doh!

As far as I know, command line is dsx only.

No, as Ken notes that stage only supports Sequential execution mode. Looks like you'd have to 'go native' for Parallel.

What happens when you click that 'Help' button down there? Usually those kind of things are spelled out there...

The web service doesn't like your XML it seems, so I suggested to take it out of the picture until you can generate 'acceptable' XML. Copy your job and take out all but the first two stages. Consider adding a Transformer between the two stages as sometimes you need to... manipulate... the data for c...

Or incorporate them into a Routine and leverage that inside the Loop. I've done that, one Sequence job that runs 'all day' and processes a series of Server jobs every 5 minutes inside a loop. It sleeps, looks for an early exit flag, all kinds of things - and wasn't that hard to setup.