DSXchange

How to Handle primary key null Handling in server jobs

There is IsNull() function. You can use that to identify null values and constraint them or pass them down a reject link. If your source is a flat file you might also want to test for zero length.

I'm curious... if there something special you are looking for? If so, you'd have to be more explicit what 'primary key null handling' means to you so we can answer the right question.

Or can we assume, like our friend has, that you just mean plain old null detection - in which case the IsNull() or 'trim and test for zero length' advice already given is enough?

Let us know!

If this is a user requirement - or a PHB requirement - just yell in their face that a primary key is, by definition, NOT NULL.

Right - guessing the OP wants to know how to avoid sending NULL values to a PK. However, given the vagueness of the question...