Null value in non-Nullable column for an Integer field

[jpohl]

I am relatively new so please consider this if there is a obvious answer.  
I have a simple job for which I am trying to move data from a MSSQL database to Redshift.  In particular I am getting an error indicating tMSSqlInput_10 Null value in non-Nullable column.  The flow is tMSSqlinput -> tmap -> tRedshiftoutput  
Within the tmap I am checking for 

row12.ClientInstitutionId = 0 ? 0 : row12.ClientInstitutionId

The system will not let me check for null (row12.ClientInstitutionId == null) as it appears that Java needs me to check for zero instead.  My thinking being that I can let the value zero go to redshift if the source data is null (or zero), otherwise send over the value

I am ammending this a bit as I have replaced the tmap and tredshift components with the tlogrow component.  I still get the same error message.  

[jpohl]

I answered my own question.  The database schema had changed and I did not change that schema on my connection