NCHAR(100) VS NVARCHAR(100)

 

 

this caused me a big headache during a SSIS package troubleshooting…

The problems is that the SSIS in my local is referring to Nvarchar(100) . When it’s deployed to the staging box, the column becoame nchar(100) which caused the ssis package to fail… gotta be consistent.