DSXchange

Thank you Uncle Kim.

Did you try creating a Key Change Column when you sorted descending? It will be a 1 for the first record in each key group and a 0 otherwise, you'd want all the 1s.

Depending on what 'send' means (pass it as an argument?) try clicking on the ellipsis (...) in the Parameters section of the second Execute Command stage and open up the first Execute Command stage which should be listed there. Then choose either $CommandOutput if you want to capture whatever the sc...

Assuming you posted your incoming data, can you post what you would want the output to look like for that sample, please?

That, the full path to the script: "/data/script/test.sh" without the quotes, of course.

The Parameters box can be left empty but is the only area where job parameters can be leveraged, when needed.

A normal close of Designer should kill those processes. Is there anything... unusual... with your setup? Connecting over VPN or via a Citrix server, for instance?

Did you make any changes, have any luck with this? I thought it was marked as 'resolved' previously but it doesn't seem to be any longer.

Sure. Once you start capturing those statistics you can do pretty much anything that you want with them. I'm guessing the next question will be along the lines of how are they captured? You have two choices - from the command line or via job control. The choice is typically driven by what you are mo...

Sending zero records to a dataset with the Update Policy set to Overwrite results in an empty dataset, regardless of what was in there before. Something else must be going on.

You can't use a "combo" action for that. You'll need to pre-qualify inserts v. updates using a lookup and then write out separate links for each with the proper data.

From Director, use the 'Add to schedule...' option. That will put it into cron and run it on whatever schedule you need.

Thank goodness.

ps. In my opinion, nothing posted here is a 'workaround' but rather the various resolutions to your requirements. A workaround implies something is broken or not working correctly and you need to go out of your way to 'work around' the problem.

Sure, you can do whatever makes sense to you. Pass in the date as a parameter and only look for 'todays' file, if you like... as long as the process runs every day.

Please post back with whatever resolution they give you.