The file has special characters which need to be eliminated before loading in the database or any further transformations.This can be done by the TEXT QUALIFIER feature of text connection Manager.
Change TEXT QUALIFIER TO #
The data is cleaned of special character #
Wow,I think this article actually was very good and informative and properly focused on SSIS.
ReplyDeleteSSIS Postgresql Read