You might also consider doing these at...

Try this:

Dim FlatCon As ConnectionManager = Dts.Connections("MyFlatFileConnection")

MsgBox(FlatCon.ConnectionString)

Have you tried putting a msgbox in the code to verify 100% that it is not running?

You could also check that the EntryPoint property for your script matches the class...

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