Home Forums Data Warehousing Integration Services SSIS 2014 - Log an error for Flat File source component when it fails to load CSV file RE: SSIS 2014 - Log an error for Flat File source component when it fails to load CSV file

  • Hi Ankit,

    This is a well known error. If Flat file source can't read a file due to delimiter or text qualifier issues, definitely the source component will fail and the error can't redirected to flat file.

    You can catch this error using on error event handler and log the error message.

    If you don't want the package to stop due to this CSV file. You have to Set a system variable named Propagate to False. You can find this variable in Event handler tab from System variable. This flag will ignore to propagate the error occurred to the parent object, by this way, the error can be mitigated. You will still see the Red box due to the error. But package will continue to run.

    Let me know, if you want further clarifications.

    Regards,

    Vijay