Are you sure it's blowing up because it's null?  Might want to try a simple select * from stg.users where try_convert(int,home_location_id) is null.

I'm sure the syntax is wrong there.

I've run...

• This reply was modified 6 months, 2 weeks ago by  daytonbrown2. Reason: added comment

I know this is an old post, but are there any updates that people want to share about what you are doing?  We're mostly SSIS/ETL with some reporting etc.  We're...

This needs to be a stack overflow answer.