Post reply

Can one send mail task be used for multiple packages

  • October 6, 2010 at 8:26 am

    #142225

    Hi,

    Can we use one send mail task for multiple packages in SSIS thru SQL Server table Configurations. Please let me know how ?

    Thanks

  • October 6, 2010 at 8:37 am

    #1232629

    goodluck (10/6/2010)

    Hi,

    Can we use one send mail task for multiple packages in SSIS thru SQL Server table Configurations. Please let me know how ?

    Thanks

    A task can only exist in one package. You can copy and paste the task into multiple packages.

    You can, however, use common configurations to set the email task properties to the same values in each package, ie. one set of configurations (one configuration per property) for as many packages as you want.

    Configurations can only be used to update the value of variables and properties.


    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

Viewing 2 posts - 1 through 1 (of 1 total)

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