Post reply

Create more than 1 functions in SSIS

  • October 6, 2009 at 10:34 pm

    #134284

    Hi

    I have a requirement of creating 8 functions in db using SSIS. Once the functions gets created I need to use them and after their use.. I can drop them. (Since this package will be used once in month and the functions made are specific for the package I would not like them to remain in db)

    I have currently added 8 Execute SQL task that creates functions. But this is cumbersome and not good design

    Is there a good way of doing in SSIS 2005.

    Any help is much appreciated.

  • October 6, 2009 at 10:55 pm

    #1062577

    You could probably specify all 8 in a single Exec SQL task.

    CEWII

  • October 6, 2009 at 11:02 pm

    #1062581

    It doesnt work..it does not recognises the other function start/end and gives error

  • October 6, 2009 at 11:29 pm

    #1062586

    Did you place GO between the definitions?

    CEWII

  • October 6, 2009 at 11:46 pm

    #1062590

    Just discovered.. that GO helps.

    Thanks!

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

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