Post reply

inpuits required for SSIS reusable component

  • March 15, 2011 at 5:02 am

    #235160

    HI,

    I want to create some reusable components in SSIS.

    Can you give me your inputs/suggestion as i am a newbie on this.

    Thanks in Advance.

  • March 15, 2011 at 5:47 am

    #1298767

    Sorry, It can't really be done in SSIS (Aside from cut+paste).

  • March 15, 2011 at 5:54 am

    #1298774

    steveb. (3/15/2011)

    Sorry, It can't really be done in SSIS (Aside from cut+paste).

    Not 100% true, though it's maybe not as easy as you would like.

    Check out this link on building custom assemblies and adding them to the GAC to facilitate code reuse.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • March 15, 2011 at 6:06 am

    #1298777

    That's true, I guess i would consider that to be a custom component, rather that a re-usable component.

    Where a re-usable component would be a SSIS transformation (for example a lookup) that you could easily re-use in the data flow. as you can in Business Objects Data Services and other etl tools.

    Though i could be wrong and that may be what the OP is after.

  • March 15, 2011 at 6:12 am

    #1298780

    That's true, I guess i would consider that to be a custom component, rather that a re-usable component.

    A nuance I had missed - I agree with you.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • March 16, 2011 at 10:36 pm

    #1299781

    marees.inspire (3/15/2011)

    HI,

    I want to create some reusable components in SSIS.

    Can you give me your inputs/suggestion as i am a newbie on this.

    Thanks in Advance.

    If you can use third-party solutions, check the commercial CozyRoc Script Task Plus and Script Component Plus. These solutions are extension of the standard tasks and components and they allow easy UI implementation and script reuse. You may also check the public script repository here for reference scripts.

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

Viewing 6 posts - 1 through 5 (of 5 total)

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