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.
n_srikanth4Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
n_srikanth4Author Commented:
No help provided
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
SQL

From novice to tech pro — start learning today.