When I first started working in BI and  data warehousing (10-ish years ago), cubes in SSAS were absolutely the goal. But the effort and expense of creating and maintaining them...

Hi,

That's brilliant, I removed it and not only did the error message disappear, but the package ran in about a quarter of the time.
Adding the variable...

Hi,

I deployed the package in SSISDB, the All Executions report gives more detail, but no other information about the error (other than it gets thrown at the very end of...

Hi Phil,

I've just run the package and again it's worked fine (delivered the flat file as it should) and once again thrown the error messages.

There's only...

I think it's appearing at the run time. When I execute the package all the validation steps succeed, and the flat file appears in the right folder location, with the right...

Hi Koisntantin,

Thanks loads for putting this list together. There's loads of new utilities and tools here that I'd never heard of (along with some old favourites!)

Are...

Hi,

Just to finish the tale...in the end the way I fixed this was to move the backup location to a different server and try again. It worked fine...

Hi,

Thanks for your help on this last week bmg002 and Sue_H .

I just picked this work up again and ran your  hello world script above bmg002. It worked fine:...

Non Production. It's part of a new development server that I've just built. Only I'm using it currently.
There's just a single user database on there at the moment, but I can create...

From checking, it sounds like the service account does have read/write permission on the backup folder unfortunately.
So that doesn't sound like the cause (despite the error message)
🙁

Not a stupid question at all. When I was first working in SSMS and worried about breaking stuff I remember being alarmed when I 'lost' Object explorer.

Hitting...

Ah that makes complete sense. I'll see what access the service account has and alter that if necessary.

Hopefully we've found a solution!

Cheers for your help everyone.