I have solved the problem after a lot more digging around...

Here is the post that actually solved it for me:

http://stackoverflow.com/questions/23523953/empty-excel-file-permissions-issue-ssis-excel-destination-buffers-large-record

It turns out that it was something related to saving a...

Thanks for taking your time to respond.

No, I do not create a new spreadsheet. I have a "File System Task" which does a copy file of a template xlsx...

Oh... and just one last piece of information.

I have this same issue even if I just hard-code the values.. the only thing that changes is the amount of rows that...

I have a standard logging and configuration setup for all my SSIS packages. Usually I only log Errors, Warnings, and any ScriptTaskLogEntry events, but it was trivial to turn...