Truncation VS Deletion
when you try to empty the whole table especialy in SSIS DON'T use delete from [Table] cause it takes time untill the query runs and delete the whole table instead use Truncate table [table] cause truncation empty the table at once