locked
VS 2010 - Renaming the default name SSIS ToolBox task use when dragged from SSIS Toolbox to Control Flow RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Team,

    I need to implement naming standards when developing SSIS packages.

    Just want to know that if there is a way we can achieve below:

    Current Functionality

    For e.g. If we drag and drop "Execute SQL Task" from SSIS Toolbox to Control Flow design area, it gives name as "Execute SQL Task", if we drag one more "Execute SQL Task", the name will be "Execute SQL Task 1" and so on.

    Expected Functionality

    When we drag and drop "Execute SQL Task" from SSIS Toolbox to Control Flow design area, it should be named as "SQL-", if we drage one more "Execute SQL Task", the name should be "SQL-1" and so on.

    And to do the same change for all tasks.

    Please let me know if its achievable or not. If Yes, then how? Thanks for your time and effort.

    Regards,
    Harshit Vasa



    • Edited by HarshitVasa Wednesday, June 11, 2014 2:15 PM
    • Moved by Kevin Cunnane [MSFT] Wednesday, June 11, 2014 6:59 PM Moving this to the SSIS forum as it's related to that topic.
    Wednesday, June 11, 2014 12:17 PM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote
    As far as I know there are no public APIs exposed from the SSIS canvas that allow you capturing the on drop event and rename the component name.

    Arthur My Blog

    • Proposed as answer by Mike Yin Tuesday, June 17, 2014 8:06 AM
    • Marked as answer by Mike Yin Thursday, June 19, 2014 5:09 PM
    Wednesday, June 11, 2014 7:29 PM