Welcome to EMC Consulting Blogs

Jamie,

I don't know who is showing their age more - me by being surprised that anyone would not know the magic number 1252 as a codepage, and what a codepage is, or you by living in a mainly post unicode era.

SQL Collation is also codepage-centric, where 1252 gets the prestigious "CP1" alias.

Not sure what happens if you pass CP1252.

Gareth

Hi Jamie,

This is a comment. I think you can solve this problem, it took me days still didn't figure out the solution. As i don't the way to post a question to you so i used the comments channel.

Problem:

SSIS package failed many times.

Reason:

data type conversion. I used the expression "01/01"+right(columnName,4) to make up a date. It is working fine even the columnName has null value. However, there are blanks in some of the columnName.

At first i thought it is spaces, even using the expression substring(columnName,1,1)=" ", it won't return ture. So, i am guessing it contains special characters such as tab, etc. Of course, the expression "01/01"+right(columnName,4)" will have data conversion problem if columnName contains special characters.

Question:

How to detect special characters in SSIS expression lang? What is the proper solution to handle such situation?

If other readers read this can they email me their thoughts?

Thanks.