W00t w00t, this one makes my 12000th point. 😎

SSRS just issues queries defined in the data sets agains the database and that's it. So it depends on the queries you write in the reports.

With SSRS you also have...

Is that absolutely necessary? It depends on the type of table and of the...

SELECT ID, Cnt = COUNT(*)

FROM MyTable

GROUP BY ID

HAVING COUNT(*) > 1;

Good luck with that. SSRS is not made to do such kind of things.

You'll have to use two seperate data sets to...

No. Can you please resend it? 😀

Either use linked servers, or move on dataset to another server.

Are you deleting connection managers?

These types of errors occur when a connection manager is deleted, but it is still referenced by a task or component.

Gary Varga (3/27/2014)

---

Although there are differences in the various employment legal systems around the world, I think there is a world of difference between being made redundant (losing the job...

The problem with loading data from Excel is that the providers "guess" the data types according to the contents of the column.

So if the first time a column contains only...

SELECT pn, rvs, resp, amount, charge, adjust = 0.0

FROM MyTable

UNION ALL

SELECT pn, rvs, resp = 'adjust', amount = 0.0, charge = 0.0, adjust

FROM MyTable

I was fired once (due to economic reasons). It was the best thing that happened to me in my entire career uptil now.

At the moment though, it didn't feel that...

gunther.vanloco (3/27/2014)

---

Ok after trying out some more I found out that adding the space as an extra column to my query and then adding it as an extra column to...

Is there a space in the empty column?

Is the column marked to be exported?

(just guessing here)

I believe a SQL query will be more suited to find the differences.

SSRS can show the results though.