I want to update records in SQL server if they already exist, but my source data doesn't have a primary key that matches the primary key in SQL server. Is it possible to identify unique records from the source by using multiple columns to match the record that needs to be updated in SQL? My source is Snowflake and the destination is ODBC connection to SQL server.
You could build your own "pseudo" key, eg. by concatenating the records into an unique key.
Warning though, this will only work if your "pseudo" key is truly unique. If the only thing in your SQL Server that makes a record unique is the key, then this doesn't work.
