SSIS 2008 package runs SLOW loading to a SQL Server 2012 instance

  • I have a package developed with SSIS 2008 on one server. It is loading data from and to separate databases on a SQL Server 2012 instance (different box) that was just installed. When it was loading to a SQl Server 2005 or 2008 instance it ran very fast. Now it is running extremely slow and I have no idea why. It does a lot of transformations that include lookups and conditional splits.

    Any suggestions are very welcome:-)

    Karen

  • 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.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply