Hi @Vicki ,
Microsoft does not currently recommend, and does not support, Automation of Microsoft Office applications from any unattended, non-interactive client application or component (including ASP, ASP.NET, DCOM, and NT Services), because Office may exhibit unstable behavior and/or deadlock when Office is run in this environment.
You may consider using File System Task to copy the excel file first and then use the copy file as source in your package to avoid the opening error.
Regards,
Zoe Hui
If the answer is helpful, please click "Accept Answer" and upvote it.