SQL Server Performance Forum – Threads Archive
Exception file in DTSWhat 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.
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.