Hello
I have an SSIS Package that writes to an Excel file.
It works successfully when...
Running through Visual Studio under my login and my colleagues
Running manually from the SSIS server under my login only
Running through a job from another SQL instance under my login only
When my colleague runs it manually or under the job it fails with Unexpected Termination BUT it actually writes to the file.
After testing, the table it copies has over 30K rows. I have changed this to SELECT TOP 100 and it works if the excel file is empty, but if the Excel File already a fairly large size that will fail. (even though it has written to the file).
So it seems to be writing to Excel that is the issue.
Does anyone know why this would be? And why would it work for my login but not two others?
Thanks
Sam



