Hi Winston Smith !
As per my understanding, u have set the flat file connection manager configuration setting correctly. You need to specify the delimiter in the connection manager.
Pls let me know which tasks u r using to achieve this task?
I think you misread my post. I didnt change anything for the flatfile connection as the flag was not present. what i changed was:
1. I have set the "alwaysUseDefaultCodePage" property of the destination OLEDB connection to True.
2. I have set the codepage property of the OLEDB connection to 65001
This allowed the package to work but I would really like to understand what a code page is, why this error presents its self so often, if its a bug and if not, what usefullness does it provide.
Regarding what im using, i simply have a flat file connection feeding to a OLEDB destination connection