I suggest you to use a task Import/Export data task, this will suffice you requirement, I suppose.

Note : It internally creates a SSIS package which you can have a...

I suppose you can use nvarchar as a datatype that would solve your problem...