Data Flow Tasks takes forever to render in BIDS

• michael.french 172

  Default port

  Points: 1472

  More actions

  April 24, 2014 at 2:45 pm

  #290580

  I am having an issue with BIDS rendering a Data Flow Task on the screen.

  The task has over 50 steps in it. The overall package has many more Tasks.

  Each click or re-position of an element takes over an hour to complete.

  The package that I am enhancing is good stable code that I have had in Production for over two years.

  Does anyone know what might be going on?

• Koen Verbeeck

  SSC Guru

  Points: 259115

  More actions

  April 24, 2014 at 2:49 pm

  #1708613

  Your package is too big. Typically you'd split it up in smaller packages so that it becomes more maneagable.

  If you have any add-ons, such as BIDSHelper, disable them first and then edit the package.

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP