DSXchange

To be fair, my job's don't abort by the time they leave the DEV environment. Sure I can write jobs that abort, but I investigate the cause and adjust so that no warnings or errors are generated. That way I know that, if any warnings or errors occur later, they're environmental, not a factor of my jo...

Kim Duke's utility ETLstats is now also hosted on OneDrive and can be accessed from here - you should not use right click initially (as it will try to save a redir HTML).

Download both ETLstats.zip and Scripts.zip from the OneDrive folder.

chulett wrote:You can only concatenate together string fields.

True, but the concatenation operator will automatically cause implicit conversion of its operands to string data type if necessary.

JE_PERIOD_NUMBER does not actually have a value?

Show us your actual derivation.

Use the debugger to watch the values on the links.

There's no size limit on a project. An empty project is quite small.

There's a limit on the space (disk space), and there may (depending on the operating system) be a limit on the number of sub-directories in a directory.

One of these is probably the culprit in your case.

Message handlers are the only way to suppress/demote the alert (warning) message that a reject like was used.

Don't necessarily believe the DBAs. They are telling you what they believe to be the case. Check. Dump the DDL and verify that they are the same - check not only data type but also size. Verify the record schema (table definition) that you have used in your job design.

Controlling operator combination at operator level is finer "granularity" than controlling operator combination at job level, which is turn is finer "granularity" than at project level. When you control operator combination in one stage it still allows other operators to be combi...

Welcome aboard.

All four tiers must be at the same version.

Therefore you cannot upgrade only two of the tiers.

Remote Device Management
Roundtable Dispute Management
Random Death Match

Or maybe IBM InfoSphere MDM Reference Data Management ?
IBM Remote Deployment Manager

Generate a constant and group by that.

Read a single line as VarChar(800) and manage its length and its parsing in a downstream Transformer stage.

This gives the beneficial side effect that your reading is a simple stream (which is as fast as possible) and that your parsing is done in parallel.

Any kind of outer join has the potential to return null columns. This is normal and does not require any special handling, other than to make sure that the receiving columns and those on the outer part of the join are nullable.

There's nothing in $UserStatus unless the upstream job actually puts it there.

You could use a routine activity to invoke one of the SDK key management routines. The routine activity will return the next surrogate key value, which will be available in the return value activity variable for the activity in any downstream activity.