Post reply

Create Reusable lookup transformation in SISIS in SQL server 2008

  • October 6, 2009 at 12:40 pm

    #211692

    I am new to SQL Server but have plenty of expereince in ETL .

    I just started using SSIS of sql server 2008.

    My requirement demands a lookup on table to return the Id by passing two input fields. These two inputs values will be passed through a paramerter in package.

    My question is Can I create this lookup as single independent object and use it in multiple packages. so tomorrow anychanges to the lookup ( for ex: query overide) ,I will only change at one place and rest will taken care automatically.

    Plesae suggest how to do or appreciate any link to the documentation.

    Also can you have mutiple control flows in one packages and set up dependencies on these control flows while running.

    Also can we create a package and use that as reusable in other pakcages.

  • October 7, 2009 at 2:29 pm

    #1063078

    any thoughts?

  • October 8, 2009 at 2:03 pm

    #1063710

    Hi,

    I am not sure if you can create a reuable look up. Here are the options for your other questions

    Also can you have mutiple control flows in one packages and set up dependencies on these control flows while running.

    You cannot have multiple control flows in one package.

    But you can achieve that using a sequence container where you can group a set of operations and set the dependency based on success/failure or based on expressions.

    Also can we create a package and use that as reusable in other pakcages.

    Yes you can create a package that can be reused for other packages. It makes use of package level variables for this purpose.

  • October 9, 2009 at 10:47 am

    #1064241

    hramineni (10/6/2009)

    I am new to SQL Server but have plenty of expereince in ETL .

    I just started using SSIS of sql server 2008.

    My requirement demands a lookup on table to return the Id by passing two input fields. These two inputs values will be passed through a paramerter in package.

    My question is Can I create this lookup as single independent object and use it in multiple packages. so tomorrow anychanges to the lookup ( for ex: query overide) ,I will only change at one place and rest will taken care automatically.

    Plesae suggest how to do or appreciate any link to the documentation.

    Also can you have mutiple control flows in one packages and set up dependencies on these control flows while running.

    Also can we create a package and use that as reusable in other pakcages.

    Hi,

    If you can use third-party component, check the commercial CozyRoc SSIS+ library. There are components for reusable Script Task, reusable Data Flow and in version 1.4 a reusable script component. You can have your logic in one place and use it from many packages.

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

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

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