Data manager Package failed

[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

[Former Member]

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

[former_member211812]

Hi Subha

Check this one

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/928884cd-7237-4b03-b79d-44427f14f9c6/ssis-p...

Regrds

Toufiq

[former_member211812]

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-e...

Hope this help.

Regards

Toufiq