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!!