Where we work, nobody releases their own code changes to live.  With source control, we have a "don't release your own changes to master" policy, but it does happen by...

I am assuming this is 1000 SSRS subscriptions.

On top of what Sue suggested, I would check for database growth of both tempdb and your report server database and log...

What is the default database of the linked server user on the linked server side?

Even if you are using the OPENQUERY method, you could try using 3 part...

Possibly an easier answer - convert User.id to a varchar.

edit - guess I shouldn't have left this open for a bit before answering... others beat me to that LOL.

reported as spam

reported as spam

what happens if you change the visible to true?  You should be able to see Excel running then and any errors that are coming up.

Since excel starts, but...

If I was implementing it, I'd do a 3 table system:
Company - which would hold the company name, the board member and the shareholder with FK's on board member...

I have 2 thoughts:
1 - are you using a network share for the excel file and if so, are you using UNC paths?
2 - does your SQL Server...

Did you provide the full path to the package?

What is the full command you are running?  Seeing the arguments you provided will likely help resolve the issue.