Migrating a SQL Server 2012 instance to a new one, I've also moved all SSIS jobs.
Testing if everything was ok I've run one of them and it failed with the error below:
Executed as user: A. Microsoft (R) SQL Server Execute Package Utility Version 11.0.2100.60 for 64-bit Copyright (C) Microsoft Corporation. All rights reserved. Started: 11:43:04 PM Could not load package "E:\MyFolder\Packagexxx.dtsx"
because of error 0xC00160AE. Description: Connecting to the Integration Services service on the computer "MyComputer" failed with the following error: "Access is denied."
Solution:
- Grant Access to SQL Server Agent Account to SSIS folder and...
- Restart SQL Server Agent.