Drew,
Wow--very clever.  That works, I would have never thought of that.  Thank you so much for sharing.  TAKE MY KARMA!

Never knew this--thanks for the article!

I run into this issue frequently; usually it's some tablix/rectangle/textbox that's causing it. One thing I do to identify the offending object is to put different background colors on...

Thanks RonKyle! #2 was the issue for me as well.

RonKyle (10/19/2012)

---

This has stymied me for some time as well. Based on the question, I took a relook. ...

awesome! glad it helped someone. I remember banging my head on it for far too long!

Wrapping your expression in a "sum" doesn't work? e.g. Sum(<expression>)

Lynn Pettis (11/11/2011)

---

philip.m.gaudet (11/11/2011)

---

Lynn Pettis (11/11/2011)

---

Have you logged into the server using the proxy account, run and saved the host key manually?

I had to do something similiar with a different...

Lynn Pettis (11/11/2011)

---

Have you logged into the server using the proxy account, run and saved the host key manually?

I had to do something similiar with a different application when setting...

okay I've finally got this fixed.

What i did was change my package to have an execute process task which executed a batch file. The batch file had...

Another interesting update, still no solution but I think I've isolated the problem better.

So putty reads stored host keys from hkey_current_user\software\blah blah. I've logged onto the SSIS machine and...

as a followup. I know that Putty reads hostkeys from HKEY_HKEY_CURRENT_USER\Software\SimonTatham\PuTTY\SshHostKeys

for some reason the package, when executed through the agent using my credentials can't read from that location, but...