I have rejects set up to redirect bad data to an excel file. I have checked the option don't generate empty file clicked. My job is still creating an empty file. Please help what should i do to avoid this thank you
The reject row can't be used together with the 'die on error' option and 'extend insert' option in advanced setting tab of tMysqlOutput component, uncheck these two option and then you can use the reject row. Right click on tMysqlOutput, select Row, and then Reject.
above mentioned options are done.but still creating empty file
i faced these errors after clicking die on error how to resolve this
exception in component tFileInputDelimited_1
java.lang.RuntimeException: Unparseable date: "1"