Jeff Moden (5/11/2008)
Actually, I don't think it was a "simple mistake"... I think it was a cost cutting measure. It doesn't take nearly the code to make something case sensitive at a binary level... it does take a lot of code to make something case insensitive.
Once again you hit the nail on the head Jeff 🙂 Case insensitivity is not as simple a problem when you're dealing with international character sets, and you have to account for a lot of little nit-picky details that aren't an issue if you're using only the Latin character set. My point is that Microsoft already has the code base to deal with all these issues, so why not give users the option to leverage the power of these features in SSIS?