I have a situation where I need to read some UTF-8 files, but for some reason the system that is providing me the files is sending me mixed formats ( ANSI and UTF-8)
Researching on the situation, the system is converting the files automatically if they do not contains any unicode data.
The problem is that if the file is ANSI and it contains some extended ascii ( for example char 160 ) the dataflow is converting the ascii 160 to asci 63 and this is causing problems on database.
I am thinking this is because the ETL is expecting UTF format but insted receiving ANSI.
Is there any way to tell the SSIS to keep the extended ASCII ?
Thanks in advance
View Complete Post