July 21, 2015 at 5:51 am
Hello everyone,
I've a dataflow task on a package. The flat file source component is unable to read one of the CSV file content as it is having unescaped DOUBLEQUOTE character, due to this it is failing in loading this file and it is stopping the entire package and does not process the next file in a loop. I would like to log this file as an error into a separate log file and allow the package to continue with other CSV files in a loop.
Please know, I've made the FailPackageOnFailure = True for data flow task. Also, the error out for Flat File Source component is setup as "Redirect Row".
But nothing is working, please advise.
Any help would be much appreciated.
Thanks,
Ankit
July 29, 2015 at 7:04 am
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
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply