The package failed during the manual deployment and execution when it was executing DW. The stage was executed completely.
I understand that the data is auto commited in SQL Server therefore it will insert and commit the data till one step before at whatever stage it must have failed.
Is there is any possibility to completely rollback the package execution when failed?
How to rollback if the package Fails during execution?