Ed Wagner (1/6/2015)

---

Jeff Moden (1/6/2015)

---

GilaMonster (1/5/2015)

---

Jeff Moden (1/4/2015)

---

I've taken to quoting the original post in many cases simply because too many people delete the original post even if they get...

There won't be performance issues. It's about 1500 extra rows. I think SSAS can handle it.

The only thing is that in Excel you have now more years to choose from...

Using pivot tables (in Excel) easily with predefined hierarchies is definately a plus.

Not having to write SQL code can be a plus for certain users. However, if something is not...

How annoying, a new QotD spammer. I send him a private message telling him nobody is waiting for email notifications for old questions.

Please provide table DDL, some sample data and desired output.

You forgot the END at the end (pun intended) of the CASE statement.

m_swetz (1/5/2015)

---

Koen Verbeeck (1/5/2015)

---

m_swetz (1/5/2015)

---

Thank you, I will take a look.

Just for my own edification, does it log to the catalog exclusively on certain errors under the project deployment model?...

m_swetz (1/5/2015)

---

Thank you, I will take a look.

Just for my own edification, does it log to the catalog exclusively on certain errors under the project deployment model? I still...

mz1derful (1/5/2015)

---

That makes sense to me too. I think the post right before yours describes what actually happened. Since there was a cursor in the stored procedure that...

That's because in the project deployment model, SSIS logs to the catalog or in other words, to the SSISDB database.

Take a look there in the views...

mz1derful (1/5/2015)

---

The thing that baffles me most is that the task that calls the stored procedure has MaximumErrorCount = 1 and FailPackageOnFailure set to TRUE. I thought once the...

Which table?

It would be helpful if you posted the actual...

ipisors (1/5/2015)

---

To me, the whole ssis/variable/data transformation route is hugely over-complicated it. SSIS tasks shouldn't be used to replicate basic SQL functions.

Just use an Execute SQL task and refer...

At second thought, it might be easier to not use event handlers but rather use a Send Email Task directly in the control flow.

Just connect it with the previous task...