DSXchange

It's not really anything like the Merge stage on the Parallel side, matter of fact what it does is merge two sequential file sources... hence the recommendation. And it uses hashed files under the covers to do the dirty work.

I don't recall much in the way of gory details as it was quite some time ago as well but I think it was about using a 7.5.1a client against a 7.5.3 server. Sequences compiled differently, we had odd issues with the XML stages which was the killer for us as we did a ton of XML work at the time. Suppo...

You could alway fix the call to the function I pointed you towards to use the correct format mask... you know, one that matches your source format.

StringToTimestamp().

Sorry, but that does not answer my question at all.

Look into the merge stage.

OK... tell us, is the shipment id actually in the file as well or is it only used to determine the filename?

That would be a question for your official support provider, perhaps there is a patch available.

It won't. That's about a bug in the SQL generation. There's no bug here, they are just seeking... enlightenment.

It is returning the count of records updated (I assume) to drive the switch to an insert when that count is zero.

First confirm for us the data type of this incoming 'date'... is it indeed a date or is it a string in that format? I suspect the latter as real dates have no 'format'.

I guess the answer to the above question could depend on what happens when you see the same shipment id later - do you create the file with the same number you used before or does it always get a new number? The latter would simplify things if all you need to do is separate the files by id and then ...

There are a number of posts here on the subject of dynamically creating output files. However, they all involve using the actual file data in the filename rather than what looks like an incremented number. Is there any reason you can't do that? Use the "shipment id" in the filename? for 10...

Start by posting in the correct forum... which I've just moved you to.

I for one am a little surprised it is working for some people as I thought there was enough of an internal architecture difference down where it matter between XP and the 'Server' versions that certain key functionality would be impacted. I know I've dealt with that issue with other software, made a...

WHY is your insert statement failing? Is it for a... duplicate key violation?