DSXchange

So rather than checking manually, build a -jobstatus check loop into your script where you parse out the result. When both have completed, based on what happened, either exit gracefully or send out your alert email(s).

That would be a question for your official support provider, unless someone here actually knows. I'd be curious, though... what are you planning on doing 'after sql' that brings up this concern? I ask just to see if perhaps you should be taking another path...

That's true... and Ray noted the solution.

And yet I still got the message...

No real answer that I know of, there are various issues seen posting here all the time. I'd just say check your "Outbox", if it is there it actually was sent... it will be there until read at which point it moves to your "Sentbox". If there's nothing there, just try again. When I...

Your source table must be partitioned in order to enable that, is it?

To use the "timestamp when the job started" in the job itself, use the DSJobStartTimestamp macro rather than a job parameter.

So true! Everyone can contribute and many people do, it's not just about us knuckleheads who are here the most. I'm still learning from things people post, especially Ernie whom we all defer to for those lovely XML / ISD brain twisters.

Hopefully you created a new single-node config file rather than changing the default one... or at least did something to ensure you have two when you are done. If you'd like us to look at the new config, feel free to post it here. If things are still running on two nodes, then either the new config ...

All of the functions are documented.

Yes, there is a substring function and there is also square brackets "[]" which is the substring operator.

Do you not have an official support provider you can ask? As a user I'm not in a position to know exactly how things work under the covers. I could guess but I'd rather not. Why not ping support and then post back here whatever you find?

You'll need to set all except the first field's "Missing" property to "Replace" so that it doesn't error and replaces each missing column with a null.

You'll also find the same information ships with the product.

Thanks! :D

Make sure you understand how StringToDate works. A date is a date, so you need to describe what format the incoming string is in, not what you think the date needs to look like.