SQL Server Performance Forum – Threads Archive

DTS Log to User Define Table

Hi All, Is it possible to insert log information of DTS package to the User define Table ? I am aware of that we can have a DTS log into file. Thx

You can using another DTS package [<img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ />], but why do you need so when you have a text file information. <hr noshade size="1">Satya SKJ Microsoft SQL Server MVP Contributing Editor & Forums Moderator http://www.SQL-Server-Performance.Com</a> <center>This posting is provided AS IS with no rights for the sake of knowledge sharing.</center>

Hi Satya, Thanks for your reply.
Actually my requirement is like:
I want to display the DTS execution related information through front end. For example, my DTS taking 40 minitues to complete the execution and it has total 13 tasks to execute. I want to show what task DTS running on current moment and what are the task that are executed successfully.

Then DTS package logs are only way to achieve that for performance aspect. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing.

]]>