February 12, 2009 at 5:30 am
Can some one please tell me what DtsDebugHost.exe is used for?
June 22, 2014 at 6:06 am
DtsDebugHost.exe.config
DtsDebugHost.exe is the execution host used by Business Intelligence Development Studio (BIDS) / Visual Studio when executing a package from the designer in debug mode, which is the default behaviour.
e.g. C:\Program Files\Microsoft SQL Server\90\DTS\Binn\DtsDebugHost.exe.config
The file can be found in both the 32-bit and 64-bit Binn folders. This may surprise some people as Visual Studio is only 32-bit, but thankfully the debugger supports both. This can be set in the project properties, see the Run64BitRuntime property (true or false) in the Debugging pane of the Project Properties.
dtshost.exe.config
dtshost.exe is the execution host used by what I think of as the built-in features of SQL Server such as SQL Server Agent
e.g. C:\Program Files\Microsoft SQL Server\90\DTS\Binn\dtshost.exe.config
This file can be found in both the 32-bit and 64-bit Binn folders
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply