That does not work

Soon as I hit the Run button the error comes put, the packages does not run at all

I have the SQL Task connected to SendMail Task

The package does not excute, it fails and says:

Nonfatal errors occured while saving the package

The connection "SmtpServer=" not found.

This error is thrown...

Do I need to add anything into Parameter Mapping within SQL Task Editor?

Well I think I have created the varriable correclty.

The following are the settings I have:

SQL Task Editor:

General

SQLSorceType: DirectInput

SQLStatement: Select vaule from SMTPSettings where id=1

(this will bring back the SMTP Server)

ResultSet

ResultName:...

As far as i know you can't edit the following, so your going to have to Import the package again, this time, under the:

Protection Level select 'Rely on server storage...

Ok thanks,

Wehn I click ont he "Evaluate Exp" button I get:

SmtpServer=

Is this correct?

As when I connect the SQLTask to SendMail there is an error saying you are missing '@'....

Thanks for the setpby set, im getting the following error:

Expression cannot be evaluated.

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%u00ae+Visual+Studio%u00ae+2005&ProdVer=8.0.50727.42&EvtSrc=Microsoft.DataTransformationServices.Controls.TaskUIFramework.

TaskUIFrameworkSR&EvtID=FailToEvaluateExpression&LinkId=20476

The variable "User::Parameter" was not found in the Variables collection. The variable might...

How can I use this variable within my SendMail task?

i.e. the Variable I have captured is the SMTP Server value

Ok Sorry Ramesh, I fixed it, I had selected an incorrect setting.

Ok so when I run this now, it completes successfully.

Where does the variable get stored? Is it only...

Thanks, Point number 4

I have select...

My SQL Table contains:

Parameters

SMTPConnection ...

Sorry I am new to SSIS so please can you elaborate a bit more….?

Yes it kind of helps, but again, does not really explain how it can be done.

I know it can be done

Make sure the file is not set to "Hidden File" within the folder

Steve,

Thanks, yes your right very hard!!

Did you read my posts in reply to your comments earlier in this thread...