Performance Issues with package, but not in BID

• BCollins

  SSC Rookie

  Points: 37

  More actions

  January 7, 2009 at 1:47 pm

  #126824

  I have developed 2 SSIS packages that run as parent-child. The parent imports a set of 4 tables and executes a couple SPROCs. The child loops though 180 directories, importing a set of 10 tables from each directory.

  Running in BID debug mode, the packages complete successfully in 35 minutes. When I import them into Integration Services and execute there, the process does NOT complete after 24 hours.

  The packages were developed in BID on the server.

  Does anybody have any insight in the cause and possible fix?

  Thanks!

• BCollins

  SSC Rookie

  Points: 37

  More actions

  January 16, 2009 at 1:19 pm

  #928486

  Can I get no takers on this issue? No ideas or thoughts? Anything would be helpful!