March 20, 2009 at 10:01 am
If I have a number of SSIS packages all using SendMail and they all use the same SMTP connection, can I create a SSIS which stores all the SendMail task which my other SSIS packages can call?
I.e. when the SMTP connection changes I only ahve to change it on once place....?
March 22, 2009 at 9:21 pm
One possibility is to put the send mail task in a package that other packages can call.
March 23, 2009 at 2:45 am
Yes thats what I want to do, but how to I make One SSIS Package call another?
March 23, 2009 at 6:02 pm
First create the sendmail package.
Right-click in the open space and select package configurations.
Add the variables that are to be passed from the parent package.
Configuration type is parent package variable and target property is value.
I believe the child package reaches into the calling package and gets the variables. You will need to use consistent names for your variables.
In the calling package, add an execute package task.
Set the location to either file system or SQL Server, depending on where you store your packages.
Create a new connection and point it to the package .dtsx file (if you save your packages in files).
March 24, 2009 at 2:15 am
Thanks very helpful!!
But a few questions.
Add the variables that are to be passed from the parent package.
Parent Package being the main SSIS package, Child being the "SendMail" task only?
Do I need to create a variable in my Child package too?
thanks
March 24, 2009 at 5:09 am
Yes to all questions.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply