• Inside the SSIS package you can make use of "On failure" flow to show the users the error