DSXchange

Sure... you should be able to pretty easily script something to pull the names from a file and loop through the list, launching the job via dsjob each time. Or build a Sequence job with the Start / End Loop stages to do the same thing.

Then you need to use a stage that allows a 'multi-row result set' which means either the UV or ODBC stages. The former is a bit of a pain to setup and use so I'd suggest the latter set to lookup directly against the (apparently small) source table rather than trying to build an intermediate data set...

Answer this question first - what do you want to happen when you do a lookup against a key value with duplicates? What should be returned?

Check the syntax for IsValidDate... I'm assuming it is taking a default since you don't mention the date's format, try adding "%yyyy%mm%dd" to it as well.

Hashed files do not allow duplicates and do a 'destructive overwrite' when a duplicate key value is encountered. I suspect this is your issue.

Your warning does not match up to the code you posted... meaning the error shows you using "-" delimiters between the date elements and yet your code as posted does not.

record ex :: 20110101, 20120606 YYYYMMDD This is a complete and accurate example of a record from your file? It actually includes the "YYYYMMDD" part? You've also said the field delimiter is a 'pipeline' by which I assume you mean pipe or '|' and yet there is not such character in your ex...

Stage variables work the same in Parallel and Server, what was 'not successful' about your attempt? What exactly did you try? Did you run the Parallel job on a single node? While not required it does simplify things.

Post some input records and detail for us the settings you are using in the Sequential File stage.

The Notification Activity stage will do that automatically in a Sequence job if you enable the 'Include status' option. Now, it won't be an attachment but you should have the basic information you need with very little effort. If what you 'need' to pull are the actual error message(s) from the job's...

Not sure about the new console tools but the Director has a "Filter..." entry on the menu or you can press Ctrl-T to open up the Filter dialogue box. There are several different criteria available but the basic one is the number of entries to show - the last 100 lines, for example. As to h...

Actually, it keeps logs for as far back as you allow it to. Don't forget you also have a Filter when you view that may be restricting you to only seeing the last few days. However, once logs have been purged (either automatically or manually) they are gone. That is the primary reason so many people ...

Yah, if you have an 'intelligent' comparison tool you might have better luck. I own a perpetual license for UltraCompare which is quite nice.

... but that way leads to madness.

I'd be shocked if foundation functions like OConv and IConv changed in any 'breaking' manner. Perhaps they would add additional optional parameters or functionality but they would be doing themselves some major damage if those functions behave differently in any detrimental sense. Do you have any de...