If you are dealing with a lot of DML operations, remove the indexes as the first step, and re create at the end after the data load happens. Are you connected through VPN? I ask bcos, when I work from home, my packages are slower than they are at work..