We have migrated from SQL2008 to SQL2016. Incl. VS2008 to VS 2015 (SSIS)
Our SCD component in the packages inserts records into the DIM table, even though this data record is already there (but in different spelling-large-small). Example: summer! = Summer 🙁
However, the COLLATE SQL_Latin1_General_CP1_CI_AS is set to DB default.
What can be the reason for this?
SSIS Provider = sqls OLEDB
Thanks
Regards
Nicole; :unsure: