Hi @Messiaux Yannick,
When I run it from SSMS it fails, saying "Error: cannot open the datafile". If I run the same package on my old laptop in SSMS it runs well.
Please edit your question, and clarify how exactly you are running the package.
Also, are you are deploying SSIS project from your developer workstation with Visual Studio to a remote SSIS run-time server?
To execute SSIS package on the remote SSIS run-time server there are few ways to do that interactively:
- Open Remote Desktop session to the remote SSIS run-time server, login to the SQL Server instance by using Windows Authentication, and execute SSIS package directly in SSMS SSIS Catalog.
- Create SQL Server Job to execute an SSIS package.