I am loading FlatFiles (.CVS) into SQL 2008 and that’s not the problem. How do I determine, using SSIS, if the flat file/s is on the server? Using the very simple attached example where would I process some sort of error/warning message, aka a record in an audit table?
The package will be processing dozens of these files so I don’t want the package to fail, just the individual Data Flow Task that is missing its file and for it to insert a record in the audit table.
Thanks in advance.