SSIS 2005 Package with many components - search for a component

  • I have created a SSIS package using the SQL Server import/export wizard. It includes more than 150 table transforms.

    Now editing the package using the SSIS designer, there doesn't seem to be a quick way to find a component by name or id. Auto-arrange doesn't seem to have any logic for sorting the components. It is very tedious trying to use the scroll bars to find a broken component.

    Any bright ideas?

    Thanks

    Gareth

  • Hmm...I think this might be asking for too much from a Microsoft product! Have you tried breaking up the packages into sub packages?

    Paul

  • That sounds too much like hard work!

    Can we report this to MS as a possible enhancement?

  • You certainly can! Search using the following keywords: "How to Contact the Microsoft Wish Program".

    Paul

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

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