Nothing tidy. Use another character as your field delimiter, or replace/delete the commas before you export the BLOB.

Great! For added transportability, I would suggest that you consider using a UNC path rather than a network drive path ...

Phil

OK, I'm running out of ideas, I'm afraid. If you edit the connection and save it again (after verifying the destination), does the error go away?

If you hover your mouse over the red cross on the Excel destination, it should give you a tool-tip popup describing what the problem is - what does that say?

Apologies if this is an obvious question, but is there a chance that you had the file open in Excel when you ran the package?

Wow, really????? :w00t: You should start spamming all men in the world.:hehe:

Is there any difference between the package that worked and the package that failed? If no, presumably logging out, back in, and re-running works again, but only once?

Can you explain...

Good work Phil.

Way too many Phils in this thread, so this Phil is signing off

Phil 😉

In your send mail task, you need to create an Expression (use the Expressions section in the task editor) for the ToLine property and set that to your EmailAddress variable.

No problem. If you can live without the leading zeros, this will get you there, I think:

"Please confirm Purchase Order " + @[User::PurchasedOrderId] + "will be delivered on "...

It looks like your DueDate variable is a Date and you are using it as if it were a String. To use it as you wish, you need to cast...

Steve Jones - Editor (6/19/2009)

---

"practise" is the English spelling, where David is located. Practice, is the US spelling.

Personally, the more I teach my kids, the more I think English...

Nice article. I thought that Edison said this:

Is there a separate quote of his just for "success"?

CozyRoc (6/18/2009)

---

John Rowan (6/18/2009)

---

Phil Parkin (6/17/2009)

---

You have mentioned "Script Task" and "Script Component" as if they are the interchangeable - they are not. Just for clarification, I'm assuming that you...

You never know when someone else might have the same issue as this in future - that's why not deleting your posts is a good idea, IMO. It's better that...