It work in the sense that the varchar was not employed as field/column type, but now this error appears. It just goes to show you Jane...!

This field contains text only, so I am a bit baffled as to why SQL is pitching a fuss.

Error 0xc02020f6: Data Flow Task: Column "Selection_Clause" cannot convert between unicode and non-unicode string data types.

(SQL Server Import and Export Wizard)