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

Thank you, John, for the considered and informed response.

All of that makes sense. But I need to get another strong coffee and read the Raw file stuff again to make...

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 mean Script Task here?

If you...

GSquared is correct. The development environment for SSIS packages is Business Intelligence Development Studio (BIDS) aka Visual Studio.

You'll find the FTP task there ready and waiting ...

Hi John

If we take away the staging table and do the import directly, using SSIS, how best do you deal with all of the FKs that need to be populated?...