SSIS package execution from SQL Agent 2016.
ISSUE :
Cannot process the SSIS package ( to process Cube) from SQL Agent Job but the package is processed successfully without any error from SQL Server Data Tools (Visual Studio) when processed manually . Environment used is WINDOWS 2012 R2 && SQL SERVER 2016.
OBSERVATION:
1.Same SSIS Package mentioned above( to process Cube) is processed successfully without any error from SQL Server Agent . Environment used is WINDOWS 2016 && SQL SERVER 2016. It seems that problem may be with WINDOWS 2012 R2.
Error Message :
Executed as user: JDADELIVERS\_dbadmin. Microsoft (R) SQL Server Execute Package Utility Version 13.0.1601.5 for 64-bit Copyright (C) 2016 Microsoft. All rights reserved. Started: 3:31:45 AM Error: 2018-02-01 03:59:34.01 Code: 0x00000001 Source: Connect AS Server Description: Exception has been thrown by the target of an invocation. End Error DTExec: The package execution returned DTSER_FAILURE (1).Started: 3:31:45 AM Finished: 3:59:34 AM Elapsed: 1668.25 seconds. Process Exit Code 1. The step failed.
Please help me in identifying the problem and the root cause of the error. . Will appreciate your help in this regard.
Thanks,
SRK.
Cannot process the SSIS package ( to process Cube) from SQL Agent Job but the package is processed successfully without any error from SQL Server Data Tools (Visual Studio) when processed manually . Environment used is WINDOWS 2012 R2 && SQL SERVER 2016.
OBSERVATION:
1.Same SSIS Package mentioned above( to process Cube) is processed successfully without any error from SQL Server Agent . Environment used is WINDOWS 2016 && SQL SERVER 2016. It seems that problem may be with WINDOWS 2012 R2.
Error Message :
Executed as user: JDADELIVERS\_dbadmin. Microsoft (R) SQL Server Execute Package Utility Version 13.0.1601.5 for 64-bit Copyright (C) 2016 Microsoft. All rights reserved. Started: 3:31:45 AM Error: 2018-02-01 03:59:34.01 Code: 0x00000001 Source: Connect AS Server Description: Exception has been thrown by the target of an invocation. End Error DTExec: The package execution returned DTSER_FAILURE (1).Started: 3:31:45 AM Finished: 3:59:34 AM Elapsed: 1668.25 seconds. Process Exit Code 1. The step failed.
Please help me in identifying the problem and the root cause of the error. . Will appreciate your help in this regard.
Thanks,
SRK.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
No help provided
1) How you execute a package in Job, means package is deployed on Integration Catelog of File path.
Would be great if you can share some screenshots.