7. You have installed SQL Server 2008 in a clustered environment. You are
installing SSIS on the SQL Server. You have installed SQL Server 2008 as a
named instance and need to tell SSIS that it needs to connect to the named
instance. What file should you edit?
A. C:\Program Files\Microsoft SQL Server\100\DTS\Binn\msdtssrvr.exe.
config
B. C:\Program Files\Microsoft SQL Server\100\DTS\Binn\MsDtsConfig.
ini.xml
C. C:\Program Files\Microsoft SQL Server\100\DTS\Binn\DTExec.exe.
D. C:\Program Files\Microsoft SQL Server\100\DTS\Binn\MsDtsConfig.
ini.config
The correct answer is B. This is the config file, which contains the settings
that the Integration Services service uses to control to which instances it
connects. The msdtssrvr.exe.config file contains the settings that control what
tracing data is being collected. The DTExec.exe.config file holds some basic
settings that are used when running SSIS packages. The MsDtsConfig.ini.
config file does not exist.
Bạn đang xem 7. - THE REAL MTCS SQL SERVER 2008 EXAM 70 432 PREP KIT P148 PPT
