If you are using SSIS package for transaferring data from one database to other database.In case of any failure or any exception on any data flow task or component level .We have to rollback our old transactional in other tables where data is already inserted.
You can set the transaction option to 'required' at package level...and 'supported' for the the components(Data) that you want to rollback in case of failure.
alternatively, put the required components in a (sequence) container and set the property to required at container level..and supported for the components within.
| Reply with attachment
| Alert Moderator