File Exists Script Task for SQL Server SSIS
Yes, it's okay. If you need to catch any exception then you should essentially catch them all. 

The reason you typically avoid this and use the most concrete exceptions possible is to provide exception-specific behaviour: an accurate log message or a different continuation once it has been logged. 

If all your exceptions are handled the same way then you can just use the catch-all. Note that you can always add a specific handler afterwards because the catch clauses are evaluated linearly.