Daniel Bowlin (8/6/2012)
Unless you need the extended international character set, you should probably stay with varchar.To change all the reports I would open the reports code (view code) and do a Find/Replace. But don't do a Replace All or you may find that you change some things you didn't intend.
This is SSIS, not SSRS!
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.