Logging in SSIS (Windows Event Log Provider)

27
17054
ssis logging

Friends,

SQL Server Integration Services includes log providers that you can use to implement logging in packages, containers, and tasks. With logging, you can capture run-time information about a package, helping you audit and troubleshoot a package every time it is run. For example, a log can capture the name of the operator who ran the package and the time the package began and finished. You can configure the scope of logging that occurs during a package execution on the Integration Services server. Logs are associated with packages and are configured at the package level. Each task or container in a package can log information to any package log. The tasks and containers in a package can be enabled for logging even if the package itself is not. For example, you can enable logging on an Execute SQL task without enabling logging on the parent package. A package, container, or task can write to multiple logs. You can enable logging on the package only, or you can choose to enable logging on any individual task or container that the package includes. When you add the log to a package, you choose the log provider and the location of the log. The log provider specifies the format for the log data: for example, a SQL Server database or text file.

In this example , I will show you how to enable logging in BIDS during package development, and how to use the SSIS log provider for Windows Event Log. First of all, in BIDS, right click anywhere in the control flow. In the context menu you will click the first option, Logging.

Select Provider type: SSIS log provider for Windows Event Log and click Add.

Now Execute the package . After package is executed, go to Control Panel – > Administrative Tools – > Event Viewer – >Windows Logs – > click on Application – > under Source tab with value “SQLISService” are package logged information.

right click on Control Flow tab and select Log Events. You will notice as shown below.

That’s it guys .. Try it ..

thanks Aparna for the short and simple doc.

Regards,
Roopesh Babu V

27 COMMENTS

  1. cialis pills Under the gate of the palace, they were led by King Yong Liu Chengxun with a group of civil and military personnel, expressing their viagra coupon 3 free pills welcome to represent the victory of the Lingnan war

  2. People s needs from ED medication can differ dramatically, so it s best to talk to your healthcare provider before deciding that a specific medication is going to be best for you based on the time it s active within your body cialis on line Ask your doctor, pharmacist, or nurse about what your medicine should do, what it should look like, and its possible side effects

  3. Bai Yuchen turned her head and said, But going to sea is not to kill people, just to walk around and have a The Most Recommended which otc male sexual enhancement pills contain viagra cialis look 5 mg cialis generic india Please note the date of last review or update on all articles

LEAVE A REPLY

Please enter your comment!
Please enter your name here

37 + = 45