Did you check
SSIS Package Configurations?
>
>I'm creating some dtsx packages .
>
>Some of these packages send emails and at the moment I have an SMTP connection in each one. So if I want to change the connection I will have to change all the packages.
>
>Is there any way I can pick up the connection from a common variable or place and use that so if I want to change the SMTP connection for all my packages I only have to do it it one place.
>
>Same thing would apply to file location etc.
>
>Thanks
>
>Nick
--sb--