First of all for all your future posts, read this article http://www.sqlservercentral.com/articles/T-SQL/61539/%5B/url%5D. This makes us save a lot of time generating table and insert scripts.

IF ( OBJECT_ID( 'tempdb..#SomeTable' )...

Can you add a print screen of the Send Mail Task Expression Editor?

Personally, I use the BEGIN/END approach as it binds the logical block of statements to the context it has been created in. And thereby making it clear to understand...

A Little Help Please (4/2/2009)

---

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...

Bob Hovious (4/2/2009)

---

Gail's right, Ramesh.

I applaud your attitude, but you will eventually find it is wasted on this particular person. I started out with...

GilaMonster (4/2/2009)

---

We've tried...

Can you post the exact error message that you are getting when executing the package?

And also check if the query returns any rows.

I'm still trying find why it...

Chris Morris (4/1/2009)

---

Good grief, it's the White...

It means that the report field will have 1 digit after decimal, rounding to 1 digit and negative number appearance format. For e.g. 123.1, -24.1, 14.0, -987.2

First make sure that the variable used in the expression is what you have declared in the package variables and also the scope in which it was declared.

When you are...

I don't why the IIF solution is not working, but may be you can try converting IIF into SWITCH and check if it works.

Here is the IIF code converted into...

Go to "Send Mail Task Editor" > Expressions > Select Property "SmtpConnection" & in Expresssions type

"SmtpServer=" + @[User::Parameter]

DECLARE @Column VARCHAR(100),

@sql NVARCHAR(MAX)

SELECT @Column = 'name',

@sql = 'SELECT [' + @Column +...

Sure...

1. Create 1 OLEDB SQL Connection

2. Drag 1 Execute SQL Task to Control Flow

3. In Execute SQL Task General Properties, Set Resultset = "Single row", Select the Connection, Set SQLSourceType...