Configuring the Integration Services Service

The Integration Services service relies on a configuration file for its settings. By default, the name for this configuration file is MsDtsSrvr.ini.xml, and the file is located in the folder, %ProgramFiles%\Microsoft SQL Server\100\DTS\Binn.

Typically, you do not have to make any changes to this configuration file, nor do you have to change the file's default location. However, you will have to modify the configuration file if your packages are stored in a named instance or a remote instance of Database Engine, or in multiple instances of the Database Engine. Also, if you move the configuration file to a location other than the default location, you will have to modify the registry key that specifies the file location.

Reference:
http://msdn.microsoft.com/en-us/library/ms137789.aspx

More Windows Event Log Info

Logon/Logoff Events

• 528 - Successful logon
• 538 - Logoff
• Logon Types: 2 - interactive; 3 - network; 4 - batch job; 5 - service; 7 - lock/unlock

Object Access

• 560 - Successful object access
• 562 - Object handle closed
• 564 - Object deleted
• 567 - Permission associated with a handle was used.

References:
http://technet.microsoft.com/en-us/library/cc751315.aspx
http://technet.microsoft.com/en-us/library/cc163121.aspx

Windows Event ID List

Reference: http://support.microsoft.com/default.aspx?scid=kb;en-us;174074&sd=tech