DSXchange

Kris, check this post.

No such thing. However, Kimball & Caserta have a book out called The Data Warehouse ETL Toolkit and it's the next best thing.

Specifically the e72758-multi-client.zip patch.

Any routine that returns a non-zero return code is considered to have failed if you have the 'Automatically handle' option on in the Sequencer. But this too can be handled without turning that option off, the method is documented in the Help.

Actually, the 'normal' way in my experience is an 'upgrade in place' where the new software is installed right over the top of the existing software. Is server B installed with the 'old' version and projects?

Granted... but just trying to ensure we're answering the right question.

You will have a problem in Production as a 'normal' job can only be run by any one given controlling process at a time. If one 'main' job has it running, any other that attempt to start it will error. You'll need to make your job a Multi-Instance job. Search the forum if you're not familiar with tha...

Welcome aboard! :D

There's nothing 'native' to the product to do so. However, perhaps by purchasing specific ODBC drivers or an iWay C-ISAM Adaptor you should be able to do it.

zuri_2000 wrote:can we obtain a solution for this using any stage apart from doing it manually.

Possibly... you could write a job to undo the changes if the process is convoluted and not something you'd want to tackle in sql.

But there's no magic solution, no.

Another groaner from Uncle Ray.

But before loading, I want to retrieve the maximum value of the Sl_No (a sequence number) Just as an FYI and to check your terminology... If this 'sequence number' is actually controlled by an Oracle Sequence object then there's no need to get any kind of 'maximum' value or increment it yourself. I...

Why take a chance? Backup anything like that you've edited and care about just in case.

The less 'cheesy' answer would be to download the patch for this from the eService website.

SQL queries to delete the data (or 'backout' the changes) and then rerun the job pointing to the correct source. Not sure what other kind of answer you were looking for.

Do you have some specific questions on this?

This is a serious issue and please help me with a solution ASAP. OK, you already got the ASAP lecture, although a little toned down from what the Grand Poobah would have said. We are all volunteers here who help when we can help - people sleep, people work, but someone will always get to you As Soo...