Skip to Content
avatar image
Former Member

Data manager Package failed

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Nov 20, 2017 at 08:23 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 20, 2017 at 08:55 AM
    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 22, 2017 at 11:34 AM

    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

    Add comment
    10|10000 characters needed characters exceeded