DSXchange

That is precisely what SortMerge collector does.

Don't "think". Check.

What "database type" is DRS using?

Change SELECT to DELETE in this query and you have it!

Don't try to do it using Information Analyzer.

IsValid() is the common function you require.

You could have had that answer even faster had you bothered to Search

Welcome aboard. You can automate in either of two ways. Using Job Sequences Set up job activities to "reset if required, then run". Using Scripts 1. Use dsjob command ( -jobinfo ) to determine the job status (and therefore whether it needs to be reset). 2. If it needs to be reset use dsjob...

That's a totally different question, not a "changed requirement".

Please begin a new thread, so future searchers are not confused.

Let me reiterate Craig's advice - if you've never edited the Registry get help. You can totally destroy Windows if you don't know what you're doing (and even if you do!).

It also counts all the control records (such as category definitions).

You need to constrain the query to eliminate these.

I normally use a file. Check periodically that the file exists (or does not exist) using a WaitForFile activity, and rename (or create) the file to notify the job sequence to shut down.

This is probably because you have a mix of formats: m/d/yyyy, mm/d/yyyy and mm/dd/yyyy.

Now, if I replace Seq File (at the other end of Reject link) with Peek, it works. So, any idea why I am not able to use Seq file to capture the rejected records. Because the columns collection is a property of the link. If you directly connect the two passive stages, then the link is visible to eac...

Please give some examples of the content in DSLink8.Eff_date field.

What format string are you using in DataStage for the timestamp?