SQL Server Performance Forum – Threads Archive
DTS Log to User Define TableHi 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.<br /><br /><hr noshade size="1"><b>Satya SKJ</b><br />Microsoft SQL Server MVP<br />Contributing Editor & Forums Moderator<br /<a target="_blank" href=http://www.SQL-Server-Performance.Com>http://www.SQL-Server-Performance.Com</a><br /><center><font color="teal"><font size="1">This posting is provided AS IS with no rights for the sake of <i>knowledge sharing.</i></font id="size1"></font id="teal"></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
This posting is provided AS IS with no rights for the sake of knowledge sharing.