paul.j.kemna (1/14/2013)
So now that I have found the problem, how do i account for these unknown characters and ignore them so that the rest of the text comes over?
Change your OLE DB source component so that it issues a query to retrieve the data, rather than just bringing the table back en masse.
In the query, use whatever DB2 syntax is necessary (:alien:) to strip out the crud before it gets to SQL Server.
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.