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
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>