when you are using SSIS to load flatfiles , make sure you know the encoding format as it may cause very weird progme.
The flat file connection manager uses Unicode as the default and if the flatfile encoding format is not unicode, it can not be loaded.
Sometimes, it is really hard to tell why two .csv file, one can be loaded but the other fails all the time.
How to check the encoding format?
In VS, open the flat file and try to save it with Encoding, the encoding format info will show up there.
Happy debugging…
No comments:
Post a Comment