Is that the only error? (as it mentions "There may be error messages posted before this ").

Does the Excel file exists when the package starts running? Are you running the...

That plan is...

Congrats with the 25000th THREAD post.

Eternal fame and glory shall be your...

Great idea!...

GilaMonster (3/25/2011)

---

Koen Verbeeck (3/25/2011)

---

GilaMonster (3/25/2011)

---

As long as no one goes off...

Nice question, thanks.

Luckily I had the Wikipedia page for RAID bookmarked, in case new QotD featuring RAID would arrise 🙂

GilaMonster (3/25/2011)

---

As long as no one goes off and starts an...

What a glorious day it will be! And the sun is shining too!

(19)

edit: 18, someone beat me to a post

Here are the different deployment methods for SSAS:

http://msdn.microsoft.com/en-us/library/ms175446(v=sql.90).aspx+

Choose the one with suits your requirements the most.

Craig Farrell (3/24/2011)

---

Craig Farrell (3/24/2011)

---

Craig Farrell (3/24/2011)

---

Craig Farrell (3/24/2011)

---

Craig Farrell (3/24/2011)

---

WayneS (3/24/2011)

---

Almost at 25,000 posts here on The Thread! At today's rate, we'll hit it tonight.

Edit: 36 posts to go....

Give it a try. You'll learn quicker and better if you try it out yourself. If you're stuck on something, post the expression you've already build here and we'll take...

Craig Farrell (3/24/2011)

---

*facepalm*...

Take a look at this excellent blog post of Jamie Thomson:

http://consultingblogs.emc.com/jamiethomson/archive/2006/01/05/ssis_3a00_-suggested-best-practices-and-naming-conventions.aspx

I use his naming conventions daily and I've seen also a lot of other people using them.

You can just store it into a ResultSet.

Select single line and store the value in a string variable. You'll avoid the for each loop this way.

Phil Parkin (3/24/2011)

---

Yes, I like that solution.

I had a look around for details of what that format function does (when used with a numeric argument) and the best I could...