Package executed through SQL SERVER AGENT throwing exception
-
Hi I have executed package through command line its working fine. The same package executed in SQL SERVER AGENT throwing exception. Please find the exception below Executed as user: NT Service\SQLSERVERAGENT. Microsoft (R) SQL Server Execute Package Utility Version 11.0.2100.60 for 64-bit Copyright (C) Microsoft Corporation. All rights reserved. Started: 5:13:13 AM Could not load package "C:\Packages\ITEMMASTER_IMPORT.dtsx" because of error 0x80131534. Description: The package failed to load due to error 0x80131534 "(null)". This occurs when CPackage::LoadFromXML fails. Source: {C45D90C3-5C86-4B77-B2D6-6A6261230041} Started: 5:13:13 AM Finished: 5:13:13 AM Elapsed: 0.078 seconds. Process Exit Code 5. The step failed.
-
Hi I have executed package through command line its working fine. The same package executed in SQL SERVER AGENT throwing exception. Please find the exception below Executed as user: NT Service\SQLSERVERAGENT. Microsoft (R) SQL Server Execute Package Utility Version 11.0.2100.60 for 64-bit Copyright (C) Microsoft Corporation. All rights reserved. Started: 5:13:13 AM Could not load package "C:\Packages\ITEMMASTER_IMPORT.dtsx" because of error 0x80131534. Description: The package failed to load due to error 0x80131534 "(null)". This occurs when CPackage::LoadFromXML fails. Source: {C45D90C3-5C86-4B77-B2D6-6A6261230041} Started: 5:13:13 AM Finished: 5:13:13 AM Elapsed: 0.078 seconds. Process Exit Code 5. The step failed.