That was it; thanks a lot for your help. The owner of the msdb database was sa and the application database was owned by a user that left the...

There's no DENY on the table, the schema or the database. The user is not part of any group and if I login as the Proxy User, I can...

Thanks for the quick response but I've already done that (sorry for failing to mention it originally) and there is none.

"if you have between 100,000 and 120,000 new rows per day, a single daily load would result in either lots of rows in the delta store, or lots of small...

*Bump - I'm interested in the answer myself as well.

The OData Source can be used to read Sharepoint lists in SQL Server 2014 but there doesn't seem to be an...

This tool is no doubt useful and I would definitely include it in my future projects that involve hundreds of similar packages but what I'm saying is that your average...

^I agree; this is interesting but I can't see your average developer using this tool since one of the points of SSIS is to get away from C#and XML. ...

Labour shortage is a myth. Offer a very good salary (I'm talking 6 figures) and then you'll see how many great applicants you'll get.

Isn't there a CDC (capture data change) mechanism for Oracle to SQL Server? I've only used SQL Server to SQL Server CDCs thus but it might be worth a...

If your service account didn't have the permissions to access your database, wouldn't other jobs be failing as well? Or is this the only time you access this specific...

I think I've found the solution but unfortunately it involves a CROSS JOIN. Let's say we have a Products table:

dbo.Products

Product

Year

Month

Count

and a Calendar table that was created on the fly...

I do have a calendar table:

DECLARE @Start DATETIME, @End DATETIME;

SELECT @StartDate = '20140101', @EndDate = '20141231';

WITH dt(dt) AS

(

SELECT DATEADD(MONTH, n, DATEADD(MONTH, DATEDIFF(MONTH, 0, @Start), 0))

FROM...

Sorry I should also say that I have no idea how to do this....

Any links or tutorials?

Thanks for the reply. I've asked around and this may be possible with Macros.... Not sure though and may have to do more research.

Although this is a relatively simple topic compared to what I'm doing now; I can see how a beginner to SSRS would struggle with getting the report to accept multiple...