If you are selecting to connect to a table in the OLE DB (or ADO) Source, try use a SQL Command instead and build the SQL yourself without the collate.

Not sure why SSIS is doing this, it might have something to do with the driver.

Thomas