Can a key column be nullable (nullable =yes). In one of the jobs I can see this. More than one columns are key columns and out of those all are nullable =No, except one column, still the job is running fine.
Want to understand how this is working.
Also, can we apply a if 'isnull' function on the key column where
nullable =yes as well as key column where nullable = no
Nullable Key Column
Moderators: chulett, rschirm, roy
Yes, key columns can be nullable. NULLs are effectively another value for a column and you're still bound to any unique constraints that are in effect for your data source/target.
Null-handling logic in the modify and transformer stages is meant to be applied only to nullable columns. You will receive warnings if you try to use IsNull() on a non-nullable column.
Regards,
Null-handling logic in the modify and transformer stages is meant to be applied only to nullable columns. You will receive warnings if you try to use IsNull() on a non-nullable column.
Regards,
- james wiles
All generalizations are false, including this one - Mark Twain.
All generalizations are false, including this one - Mark Twain.
Thanks.
I expected the same. But now the job is aborting with error
Using "null" conversion with non-nullable input
APT_CombinedOperatorController(0),0: Null handling function called on a not nullable field.
for the only column which is key and nullable is Yes and not for the rest of the key columns which are already nullable=no. This is strange.
I expected the same. But now the job is aborting with error
Using "null" conversion with non-nullable input
APT_CombinedOperatorController(0),0: Null handling function called on a not nullable field.
for the only column which is key and nullable is Yes and not for the rest of the key columns which are already nullable=no. This is strange.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: