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..
Good Luck 🙂 .. Visit www.sqlsaga.com for more t-sql code snippets and BI related how to articles.