Import Error Exception from HRESULT: 0xC0010009

1. Problem

   An Import or Detailed Planning Import process errors out. Task log execution results show:

   Unable to create SSIS package

   Exception from HRESULT: 0xC0010009 

   Cause

   This error occurs when re-running an existing import process and the source (text file, Excel file, view or table) being imported has one or both of the following changes:

   • Column name has changed. For example when the import process was originally created it had a column/header labelled Cost Center but the column/header is now called CC
   • Column is missing. For example when the import process was originally created it had a column/header labelled Cost Center but that column no longer exists

   Due to mismatch in naming or missing column/header  Prophix no longer recognizes how to map one of the fields in the Target Mapping tab of the import process. 

   Solution

   1. Go to the Target Mapping tab of your import process to confirm the target and source mappings (this print screen assumes an import data process, but the step is the same for a Detailed Planning Import)
   2. Open your source (the text file, Excel file, view or table you are importing). Note: you can identify your source by looking at the Source tab of the import process. 
   3. Do the column names match the description ins the source mapping column you checked in step 1? if not is a required column missing, or has it been renamed?
   4. If the column is missing re-add it to the source text file, Excel file, view or table you are importing. If it has been renamed, then remap the appropriate field. In this example, we are import from Excel and the column name for Customer has been abbreviated to Cust. We will update our target mapping so the Target Customer maps to Source Cust  
   5. Re-run your import.