The query is correct, I believe the INTO keyword is optional. Using another table name with no text fields produces the intended result, much like a FoxPro APPEND FROM statement.
Data Transformation Services did indeed impose its own collation instead of preserving the collation of the database being exported. This is evil!!
Randy Hersom
President, Habilitation Software Inc.