Hi,
I have an SSIS package that inserts data from an XML file.
The Sales header information is added using SQL Task, and it goes to a DataFlowTask
where it loads the XML again using XMLSource, and inserts the subrows to an OLEDB Destination.
The problem here is, If any error happens inside DataFlowTask (Truncation or DataType mismatch), The Package fails, and the header row will remain in the table.
How can I efficiently add errorhandling to remove the header info if the package fails ?