Recently we are getting the below error.
Data Flow Task:
The column “ABCD” cannot be processed because more than one code page (XXXX and
YYYY) are specified for it.
By default AlwaysUseDefaultCodePage property value is false.
It means the conversion from Unicode (65001) to ANSI (1252)
is not done automatically within the data source step.
By setting it true it will done automatically.