ErrorCode and ErrorColumn in Excel Destination

ErrorCode and ErrorColumn in Excel Destination

• John Fiala

  If you want to do this manually (i.e. not programmatically), you can open the Advanced UI for the Excel Dest, and go to the "Input and Output Properties" tab.  There, under "Excel Destination Input", you can look through the colums. As you click on each one, look for the "ID" property on the right that has the value you found in the ErrorColumn field of the error row.
  
  Let me know if this helps or not.
  
  Thanks,
  Mark
  
  

• Ferry Meijndert

  Hi Rob
  
  I want to do something similar but write out the column name to a table along with the data when rejected.  Did you ever figure out how to do this
  
  Thanks
  
  Marcus
  

• Fluxetreflux

  Hi
  
  How would you do this programmatically Ideally, I'd like to include the actual column name as another output column in my error destination table. Also, is it possible to obtain the error description as well as the ErrorCode (similar to what you might see in the Execution Results pane when debugging)
  
  Thanks
  
  Rob
  

• cessna172k

  While it's fairly easy to add an ErrorDescription column on top of the ErrorCode, it's NOT so easy to add an ErrorColumnName on top of the ErrorColumn numeric ID value, because of all the ifs ands and buts that determine whether the column name is readily available or not. (For example, did the preceding component have synchronous or asynchronous outputs, and so forth.)
  
  You can run your error output through a Script Component and try looping through the columns in its InputColumnCollection and VirtualInputColumnCollection looking for the ID value that you've got in the ErrorColumn column to see that this information is usually unavailable.
  
  -Doug
  
  
• ErrorCode and ErrorColumn in Excel Destination