DSXchange

The extra information you need is in the related log for the activity that failed causing the sequence to fail.

(Auto) decides Entire for reference inputs to a Lookup stage.

Excellent. Presumably whatever you tried earlier to "shrink" the image still did not result in an image of the correct size. Please mark this thread as Resolved.

It's important to know. Otherwise, what is the family name of DENNIS JAMES or JAMES DENNIS ? Is there a business rule that explains how to handle names in which the comma is not present? What if there are two commas? GATES, III, WILLIAM F What if there are three commas? SCHULTZ, JR, Charles, Admiral...

Does the comma always appear?

How will you handle:
WILLIAMS, Mary-Jane Fiona
WILLIAMS, Mary Jane Fiona
WILLIAMS Mary-Jane
DE WORDE, William
DE WORDE William

Get more storage. BCP (the bulk loader for SQL Server) does not require any permanent storage, but does require temporary storage for the data file.

Yes, though obviously separately for separate fields.

NullToValue() is probably sufficient for your first example.

The two ends of the range will be derived by simple arithmetic involving integer division by 200 and modulus operations.

No. My response was predicated on use of a database. There are no "system tables" for text files. If you do have these (for example schema files) you could adopt a similar approach.

What do you mean by "validate"? Do you have specifications?

Use a server job that gets the next available key (MAX(keycol) + 1) from the table and loads it into its user status area. Pass that as a parameter to the actual job and add it to the expression you currently have.

The job captures the sqlcode value from the target database. This comes into a Transformer stage in the Shared Container which uses DS macros and other techniques to add the project, job name, date, user and any other information required for loading into an error recording table.

You need to pre-process the data, perhaps with DataStage, to generate compatible (comparable) values.

Write to a text file or FTP, get BCP to load the data on the Windows machine.

Not in a single pass.

Numbers are not re-used. You have 146 jobs, the highest-numbered of which is 189. When a job is deleted, all the tables and directories associated with it are deleted. So, for example, you may not have an RT_LOG42 hashed file.