Case sensitivity in data can trip us up unknowingly and Integration Services is no exception. Depending on the components we’re using we may notice different behaviour.
Without understanding the way case sensitivity is treated within SSIS packages, we may see unexpected results with string comparisons.
Let’s clear things up and dive into a few examples to see when they behave differently.
Click through for three examples. One more that I’d add is Script components, which are C# or VB. Both of the languages are case sensitive, and string comparison in .NET is case sensitive unless you set StringComparison to one of the options that ignore case.