Thank you for that quick response.

But why don't i get the error when my EXPRESISION is "(DT_TEXT,1252)City",

and I do get the error when it is "(DT_TEXT,1252)City...

Hi,

I am brand new to SSIS, and data types. Can you provide direction on this simple test i am doing with a DERIVED COLUMN?

(1) SQL Server 2005 OLE DB...