To begin, run the following query:
SELECT *
FROM Log_DataTransformation
WHERE StatusFlag = 'F'
ORDER BY StartDate ASC
This query will return all data integration steps that have failed across all time, with the latest failures at the top.
Scroll to the right to find the following columns:
- ErrorCode
- ErrorDesc (Error Description)
- ErrorSource
These three columns provide detail on what the issue is and will give direction where to look next.
The column [StoredProcedureName] will show what stored procedure the failure is related to. This may require looking into the stored procedure. Please use caution when reviewing these. It is recommended a backup or copy of the Stored Procedure be done before making any changes.
The [SourceTableName] details where the data is coming from and the [DestinationTableName] column describes where the data is being inserted in to.