DSXchange

So... you figured this out?

Yes, the order. Set the "previous" value last.

Another thought, dump the file/aggregator approach and use DSGetLinkInfo() after the job completes to see how many rows were written to the reject file. Email based on that count.

Constraints are filters. Why not filter them down a Reject row and set it to abort after 1 row? Is that not an option in the parallel transformer?

A1. It's "enabled" or you wouldn't be in it.

A2. Search the forums for dsdlockd for discussions on this.

It's documented in the User Reference:

http://publibfi.boulder.ibm.com/epubs/pdf/25126160.pdf

Also mentioned in the 'System Description' document as well.

The previous query that you didn't post?

The anonymous block changes it from SQL to PL/SQL and the 'error' basically doesn't get reported since there's no exception handler code.

Source and Target in the same instance? If so, you can just do this in sql. What kind of volume? You could load all source records into a hashed file and then check each target record against that, deleting any that don't get a hit. Or bulk load the source keys into a work table and again use the sq...

We think so, too.

From the command line just add the InvocationID to the job name with a 'dot' separator - so JobName.ID rather than just JobName.

Welcome. :D Do you already have a mechanism in place to capture deletes in the source system, something like CDC perhaps? Or is that part of what you'd like to discuss here? Hashed file reference lookups are the heart and soul of the Server product, you should be using them to pre-qualify not only y...

Probably the simplest way to accomplish this is via 'at' on the ETL server since you're talking 'one time' scheduled runs. For a recurring schedule, cron. Suggest you actually schedule a generic job run wrapper script with the job particulars passed in rather than attempting to directly schedule dsj...

Wait means wait until finished, you can't specify how long. How soon did the 81002 error show up? Does that match the timeout value you specified in the Administrator?

Exactly. Talk to your DBA or google for 'AMP Lock table overflow' for discussions on the issue.

You might want to provide a wee bit more detail as to your requirements. All we know now is your job need to run for two years, and so won't be finished until early 2011.