Yep.  That's what I'm doing.  Thanks to all for the good advice.

In that case, the record will be updated with the name.  An insert in that case would be the wrong logic and thus should fail based on the constraint I...

Thanks, but both can be blank.  I can have a record with a blank name and email address, any unique names and an email address, but not both a unique...

Correct Jeff, execute SQL Task is your friend here.

Thanks Ant-Green.  Nice to have confirmation.

I was maybe not clear enough, email address alone is not unique in the table  First, last and email address is unique.  An email address can appear multiple times with...

So very strange.  Trying those exact queries again today, and working exactly as expected.  Even tried setting RCSI on and off, no change.  Thanks for checking.  Much appreciated.

Interestingly enough, I...

Exactly Jeff.  But you didn't read down far enough 🙂

The current environment I'm in is pushing to move to datalake/databricks, but I actually don't know what problem we are trying...

If you are familiar with SSIS, then use that.  According to MS and others, SSIS is actually faster than BCP.  Although, I've never fully tested myself.  That being said, SSIS...

OK.  I know this is an XMAS post and I shouldn't read too much into the code, but holy cow, those where Clauses (like what I did there) gave me...

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 2 years, 10 months 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.