How to protocoll running tasks?
Hi,
I am trying to find out how to get a detailed protocolling of my runnung SSIS SQL tasks. For example some SQL tasks contain long SQL scripts and need a lot of time and I would like to track them.
Any tipps?
Thank you!!
Sergio
Greetings from No Planet!
February 26th, 2011 8:27am
What do you mean by detailed protocolling ? TCP IP???Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
Free Windows Admin Tool Kit Click here and download it now
February 26th, 2011 8:28am
Sorry I actually mean logging. What I want to do is to log my SQL execute tasks into a simple txt file and later into a database.Greetings from No Planet!
February 26th, 2011 9:12am
Hi,
I am trying to find out how to get a detailed protocolling of my runnung SSIS SQL tasks. For example some SQL tasks contain long SQL scripts and need a lot of time and I would like to track them.
Any tipps?
Thank you!!
Sergio
Greetings from No Planet!
Hi,
You've the SQL Profiler to inspect the queries that your package launch. You can configure the template to obtain a lot of data, even the connection protocols (watching Existing connections or Audit logins)
RgardsVctor M. Snchez Garca (ES) (BI) Hope this help. Please vote if you find this posting was helpful. if this is an answer to your question, please mark it. http://bifase.blogspot.com | http://twitter.com/atharky
Free Windows Admin Tool Kit Click here and download it now
February 26th, 2011 9:15am