• Status: Solved
  • Priority: High
  • Security: Public
  • Views: 86
  • Last Modified:

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.
0
n_srikanth4
Asked:
n_srikanth4
  • 2
1 Solution
 
Arifhusen AnsariBusiness Intelligence Developer and AnalystCommented:
First question:

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.
0
 
n_srikanth4Author Commented:
Hi Ansari,

     Please find the screen shot(Process_details.jpgCube Process using the SSIS Package) for details of your question?

Thanks,
SRK
0
 
n_srikanth4Author Commented:
No help provided
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now