Hi Thom A, unfortunately I can't find the solution in source control and I had to export the dtsx file straight from the server 🙁

• This reply was modified 2 years, 5 months ago by  Jim-S.

I like it, thank you 🙂

Mr. Brian Gale, thank you so much, this works perfectly.

Also, thanks for the detailed reply, I will take some time to have a read over it.

I opened the same rdl files using Power BI Report Builder, published them to the service and set up the subscriptions from there. They are now working fine. I guess...

Yes my data source is caching the credentials, I have posted it above

Just to add, I came across the following page https://stackoverflow.com/questions/33385147/sub-report-could-not-be-shown-sub-report-works-separately-not-with-main-repor , which is very similar to what I'm doing and also the same error message.

It appears that this...

Hi Lowell,

Thanks for your reply, the sub report is the same report multiple times (just with a different parameter each time), so it doesn't make sense why it would work...

I believe it's failing on the flat file destination task, if I replace the destination task with a sort task, it returns all the data without any error.

I did initially...

Thank you Scott, appreciate your help.

All, thank you for taking the time to reply. I really appreciate it.

When I log onto the same machine the package is deployed to it appears to run a bit...

Thank you for your reply.

I am sorry but I missed out something important from my question. In order to get SSIS connected to the azure SQL database, we had to...

Awesome, thank you both for your help. I will add the additional code to check the transaction state.

Hello, just wanted to add an update to this in the hope that someone can help.

Within visual studio, I have a single partition called 'template' which I have updated with...

I finally managed to get my code into production.

Jeff and Scott, you both hit the nail on the head when you mentioned estimated v actual rows and joining heaps. I...