Skip to Content
0

Data manager Package failed

May 23, 2017 at 10:21 AM

92

avatar image
Former Member

Hi ,

We have data manager package called Execute_Process_Drillthrough_Incremental_Load which runs weekly once on Saturday at 1 PM and the amount of data loads is almost 18 GB file from PDI ,this is the custom package which loads data from PDI into BPC alliance drill through DB.With the below log i am not able to conclude what was the problem.Please help me on this

The below is the log:

Error------------------------------ An error occurred while executing a package.Package Error Events: ErrorCode = -1073573551Source = Execute Process TaskSubComponent= Execute Process TaskDescription = In Executing "C:\Program Files (x86)\Microsoft SQL Server\100\DTS\Binn\DTExec.exe" "/f "\\AEPRDSAPAPP1\Webfolders\Data_Load_Packages\Drill_Through_Data_Load_Full_Load.dtsx" /X86" at "", The process exit code was "1" while the expected was "0". IDOfInterfaceWithError= {C81DFC5A-3B22-4DA3-BD3B-10BF861A7F9C} --------------------------------------------------------------

Regards,

M.Subbaraju

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

avatar image
Former Member Nov 20, 2017 at 08:23 AM
0

Hi Subbaraju,

As this is very generic error so we can't pin point on one particular reason.

Please go through this link

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/cbfd98f9-f3df-421e-a100-d9b61b802c17/ssis-execute-process-task-error-process-exit-code-was-1-while-the-expected-was-0?forum=sqlintegrationservices

Hope this help.

Regards

Toufiq

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Nov 20, 2017 at 08:55 AM
0
Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Nov 22, 2017 at 11:34 AM
0

Hi Toufiq ,

I would like to tell you we have installed security patch updates on server on Wednesday ,from thursday only this package have been failing.rest other package are running fine.

Still it is failing ,yesterday we have enabled DB logs ,DB logs giving update conversion and some validation error ,i am not sure exactly what error it is.

Still i have doubts.

Complete impact of the Security patches Potential Policy or

Other changes impacting the permission structure of the Database or file structure

Can you guide on this?

Regards,

M.Subbaraju

Share
10 |10000 characters needed characters left characters exceeded