Post reply

SSIS: 1 Configuration File Many Control Items (Name property problem)

  • April 30, 2008 at 3:17 am

    #154319

    Hi,

    For the sake of simplicity, lets say I have created an SSIS package with:

    One "Configuration File" and two "Send Mail Tasks".

    The Configuration file has the following property in it:

    Configuration ConfiguredType="Property" Path="\Package\FailureNotify.Properties[ToLine]" ValueType="String">

    The first "Send Mail Task" has the Name property of FailureNotify and at runtime picks up the values from the Configuration file.

    I would like the second "Send mail task" to also pick up it's values from the same Configuration file but to do that I would have to give it the same name property as the first Send Mail Task which is obviously not allowed.

    Can anybody assist?

    Cheers

  • April 30, 2008 at 4:13 am

    #808895

    I would use a global variable for the ToLine and add it to the configuration file. Then assign the variable to the ToLine properties of both mail tasks.

    Peter

  • April 30, 2008 at 7:20 am

    #809021

    Good suggestion!!

    Any others?

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

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