Post reply

The most lethal Task or Component is SSIS is Script Task/Component

  • October 5, 2010 at 7:09 am

    #1231656

    My vote would be for either the Sort Transformation (atrocious!!) or the Partial Cache Lookup on the Advanced properties of the Lookup Transform.

    If you write solid code, your script can be screaming fast.

  • October 5, 2010 at 7:11 am

    #1231661

    Either Sort

    or

    Slowly Changing Dimension task.

    both are horrible..

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

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