Glad you found it. Thanks for posting the solution.

How are we supposed to do that when we don't know the table schema and what...

First of all you have to be 100% sure the reports are correctly configured.

If they are, my next step would be to check the SSRS logs.

That's kind of vague advice.

You should see this as an opportunity to...

Bob Cullen-434885 (10/10/2014)

---

We're still on 2008 R2 so I've never used THROW. But I was aware that it was a new (ish) feature, so my reasoning was - well, why...

First I would remove the data I don't need using a conditional split.

Check for KB and bytes and sent those rows to an output you don't use.

Next I would use...

Abhijit More (10/10/2014)

---

Using lookup transformation with FULL cache will add an overhead on memory whereas we have other application accessing the same server. another concern using lookup will be using...

A common mistake is to plot data onto a map without normalizing the data first.

This basically just plots a population map.

This XKCD cartoon explains it better than I ever can...

I just changed a query where there was an ISNULL function to the "column IS NULL" function so that an index could be used.

So no, I haven't encountered a case...

I guess you are trying to use CampaignCode as a type of relationship between the two fact table.

However I guess this is not a true PK-FK relationship, meaning this is...

Is the single quote present right before you sent the data to the Excel destination?

If yes, remove it using a derived column.

If no, this means Excel has put it there...

What do you mean with "fetch reports"?

The error seems clear to me: there are issues with the data source.

Are the reports using shared data sources?

Is it possible to just change...

Hmmmm, I had to guess the intent of the question.

As stated in the MSDN page the explanation linked to:

Because the THROW statement does not allow for substitution parameters in the...