// execute package
PC.Execute();

// check for error
string Error = "DTS Execution failed: ";
bool IsError = false;
// go through steps
for (int i = 1;i<=PC.Steps.Count;i++)
{
// check step execution results
if ((int)PC.Steps.Item(i).ExecutionResult==1/*DTSStepExecResult_Failure*/)
{
int ErrorCode,ErrorHelpContext;
string Source, ErrorDescription, ErrorHelpFile,
ErrorIDofInterfaceWithError;
IsError = true;
// get detailed error information
PC.
Steps.
Item(i).GetExecutionErrorInfo(
out ErrorCode, out Source,
out ErrorDescription, out ErrorHelpFile,
out ErrorHelpContext, out ErrorIDofInterfaceWithError);
// construct error message
Error += "Step "+PC.Steps.Item(i).Name+
" failed with error code "+ErrorCode+" in "+
Source+" with folowing error message\""+
ErrorDescription+"\", help file: "+ErrorHelpFile+
" context "+ErrorHelpContext+
" error in interface: "+ErrorIDofInterfaceWithError;
} // if
} // for

PC.UnInitialize();
PC = null;
if (IsError) throw new DTSPumpUploadFailure(Error);