Hi-
I am having a scenario where i have to load various files from a folder into a table. But few files having uneven number of columns. In that case I have to move those files into a different location. All these files are getting loaded through an foreach loop container. I don't want the package to be failed. I only need to move those files to a different location and the package will pick the next file to process.
I have followed the approach of setting the event handler of the package to on error and making the "propagate" property to true of the foreach loop and settng "maximumerrorcount" property to some value (let say) 15. But still its getting failed in the DFT (In source) inside foreach loop.
Please provide some insight, how to deal with such kind of scenario.
Regards,
Partha