What exactly is wrong with the Excel Destination in SSIS?

As you can choose both parameter values, you need a multi-value parameter, so you need to work with IN in your main query.

You can use the following query to populate...

I really like the change. Personally I like the MSDN model the most: OP (or mod) can mark a reply as answered, people can upvote posts or propose a reply...

No. SSAS works with Windows Authentication.

I'm not 100% sure, but I believe there's a work around where you create local users on the server with the same usernames as your...

Not that I know of unfortunately.

Interesting "feature" of SQL Server 🙂

Pfft, you wish.

Sean Lange (2/7/2014)

---

Ed Wagner (2/7/2014)

---

I like the new "mark as answer" functionality. The green threw me at first, but it sure did draw attention to the post, which is...

GilaMonster (2/7/2014)

---

Koen Verbeeck (2/7/2014)

---

Ed Wagner (2/7/2014)

---

That's one thing I really enjoy about SSC. The people here aren't paid to answer questions. We do it because we enjoy doing...

Ed Wagner (2/7/2014)

---

That's one thing I really enjoy about SSC. The people here aren't paid to answer questions. We do it because we enjoy doing it, which improves...

Report Design: Naming Excel Worksheets

Found after 30 seconds of Googling.

Jeff Moden (2/7/2014)

---

Koen Verbeeck (2/6/2014)

---

Steve Jones - SSC Editor (2/6/2014)

---

However, this way they can give feedback that something worked. We are talking about how to best get other info from...

dwain.c (2/7/2014)

---

Steve Jones - SSC Editor (2/6/2014)

---

However, this way they can give feedback that something worked. We are talking about how to best get other info from the "crowd" on...

Is your caps lock broken?

This error is mostly due to memory pressure.

Make sure SQL Server has enough memory to finish the operations.

Maybe because you switched values in your example.