![T-SQL.RU | ALTER TABLE SWITCH statement failed. Check constraints or partition function of source table [XXX] allows values that are not allowed by check constraints or partition function on target table [YYY]. T-SQL.RU | ALTER TABLE SWITCH statement failed. Check constraints or partition function of source table [XXX] allows values that are not allowed by check constraints or partition function on target table [YYY].](http://www.t-sql.ru/image.axd?picture=%2F2014%2F07%2F20140711_01.png)
T-SQL.RU | ALTER TABLE SWITCH statement failed. Check constraints or partition function of source table [XXX] allows values that are not allowed by check constraints or partition function on target table [YYY].
Oops...I forgot to leave an empty SQL table partition, how can I split it with minimal IO impact? - Microsoft Community Hub
![0392 – SQL Server – SSIS – OLE DB Destination – Table Fast Load – Check Constraints option | SQLTwins by Nakul Vachhrajani 0392 – SQL Server – SSIS – OLE DB Destination – Table Fast Load – Check Constraints option | SQLTwins by Nakul Vachhrajani](https://nakulvachhrajani.files.wordpress.com/2016/10/0392-sqltwins-ssis-checkconstraints-oledbdestination_unchecked.jpg?w=640)