Forum Discussion

San29071979's avatar
San29071979
Copper Contributor
Dec 15, 2022

SSIS package failed collation issue.

Hi Experts,

 

SSIS package failed collation issue. (Cannot resolve the collation conflict between latin1_general_cs_ks_ws and latin1_general_ci_ks_ws . unable to find which table and coulmn causing this issue,. Need Help

 

 

  • Becky_York's avatar
    Becky_York
    Copper Contributor
    Dec 19, 2022
    You'll get this problem when your user databases have a different collation from the master database. When you make a temporary table it uses the collation from master/tempdb (which should always be the same). Then when you inner join to a table in your user database you'll get a collation error.
    To fix this.
    short term #1 always put collation statements on your temporary tables to match tables in your user database.
    long term #2 ensure that your master/tempdb collations always match your user databases.

Resources