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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics