Exception file in DTS | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Exception file in DTS

What is exception file in DTS’s Transform Data Task Properties under Option tab? Is it where the DTS logs are written? CanadaDBA
No, rows that could not be inserted due to sql error are written there.
So, where are located DTS log files? CanadaDBA
Open package, righclick anywhere inside, choose "Package properties", click on "Logging" tab.
Enhanced logging saves information for each package execution, allowing you to maintain a complete execution history and view information for each process within a task. You can generate exception files, which contain rows of data that could not be processed due to errors.
Satya SKJ
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.