DSXchange

I think you need to make sure that the value IS passed to the job.

C:\IBM\InformationServer\Clients\Classic\DSDesign.exe is the default location.

If you have chosen to install the clients in a different folder, you will need to adjust the pathname. Use Windows Explorer search facility to find the executable.

Yes. It's there in 7.5 server edition. It's in the Database folder in the Palette.

Use a server job in which you can interpose a blocking operation (these are banned in parallel jobs). Otherwise there are no guarantees - among other things it depends on the level at which you are locking, the number of rows per transaction and the array size.

Option 2 will not suffer from the queries locking the tables that you are attempting to update (assuming the jobs are run consecutively).

Have you investigated using SQL Server Enterprise stage?

If you are using version 8.1 you can use a Distributed Transaction stage.

Copy the appropriate lines from the DSParams file in the DEV project to identical locations (preserving sort order) in the DSParams file in the TEST project. Note that there are two groups of entries (definitions and values) for environment variables in the DSParams file.

Search DSXchange for "vertical pivot", because this is precisely what you have specified. However, what you have specified does not appear to me to be a particularly meaningful exercise as stated - are you also carrying through the original key from the source.

What partitioning are you using? Would level of locks is table A using (table, page or row)?

No. Each SCD stage requires two inputs and two outputs.

The maximum line length, whether you use TERM or SET.TERM.TYPE, is and remains 2048 characters.

You can not get longer line lengths using LPTR.

... then manually clean up the Ascential entries from the Registry, because the uninstaller does not do a complete job of doing so.