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_member211812]

Hi Subha

Check this one

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

Regrds

Toufiq