DRAG DROP
A new dedicated server is used to execute resource-intensive SQL Server Integration
Services (SSIS) 2012 packages. The environment that you are deploying the packages to
has the following constraints:
The operating system is Windows Server 2008 R2.
The SSIS packages are stored in the SSIS catalog.
Some of these SSIS packages use 32-bit custom components.
You need to install only the components that are required to deploy and run the packages on
the new server.
Which three actions should you perform in sequence? (To answer, move the appropriate
actions from the list of actions to the answer area and arrange them in the correct order.)
Answer: See the explanation
Explanation:
Box 1: Create the SSIS catalog.
Box 2:
Box 3:
Note:
Step 1:
Step 2:
If you require 32-bit versions of the Integration Services runtime and tools to run certain
packages in 32-bit mode, you must also install SQL Server Data Tools (SSDT).
Note:
For a complete installation of Integration Services, together with the tools and documentation
for developing and managing packages, select both Integration Services and the following
Shared Features:
* SQL Server Data Tools to install the tools for designing packages.
* Management Tools – Complete to install SQL Server Management Studio for managing
packages.
* Client Tools SDK to install managed assemblies for Integration Services programming.
Step 3: How to Modify the Service Configuration File to Connect to a Named Instance of
SQL Server
To connect to a named instance of SQL Server, you must modify the service configuration
file, MsDtsSrvr.ini.xml.
You cannot install SSIDB catalog unless you have installed the server.
Install Database Engine Services, Integration Services, and SQL Server Data Tools.
Create the SSIS catalog.
Configure the MsDtsSrvr.ini.xml file to use the msdb database.
0
0
My answer is
Install .Net FW(its prerequisite to install server)
Install DB Engine , Integration Service and Management Tool that we need to create SSIS Catalogue.
Create SSIS Catalogue.
0
0
I agree with Min
0
0
what about msdtssrvr.ini.xml??? does this needs to be configured?
0
0
https://msdn.microsoft.com/en-us/library/ms143731.aspx
0
0
Install .NET FW
Install Database Engine Services, Integration Services, and SQL Server Data Tools.
Create the SSIS catalog.
0
0
.Net framework is already installed with 2008 R2. It looks like John Sno does know something after all.
0
0
I do not think you need the msDtsSrv.ini as no custome configuration like a named instance.
I also think you need to enable the .Net framework:If you run Setup on a computer with the Windows Server 2008 R2 SP1 operating system, you must enable .NET Framework 3.5 SP1 before you install SQL Server 2012.
https://msdn.microsoft.com/en-us/library/ms143506(v=sql.110).aspx
0
0