clipped from: blogs.conchango.com   

The fix is simple. Set AlwaysUseDefaultCodePage=TRUE on the offending OLE DB Source component and it works fine. There are some caveats to this and these are detailed by Larry Pope in the seconc post of this discussion thread: http://forums.microsoft.com/msdn/ShowPost.aspx?PostID=117014#117014