You are a database developer and you have about two years experience in creating
business intelligence (BI) solutions by using SQL Server2008.
Now you are employed in a company which is named NaproStar and you are in charge of a
SQL
Server 2008
Integration Services (SSIS) instance.
The SSIS instance has the packages stored in a SQL Server 2008 instance while another
SSIS instance had its packages stored in a shared directory.
According to the order of your manager, you need to deploy the package from the SSIS
instance to another
SSIS instance.
In order to achieve this goal, which command should be executed?
A.
The dtexecui command should be executed
B.
The dtswiza command should be executed
C.
The dtutil command should be executed
D.
The Dtexec command should be executed
Explanation:
Manual package deployment You can move your SSIS packages to a destination folder by
copying them manually, by using a source-control tool that handles file deployment, or by
creating a script or an application that handles the deployment. If you store your package in
SQL Server, you can either use the DTUtil command-line utility that comes with SSIS to
deploy your packages to SQL Server or manually import them through SSMS. Using
DTExecUI to Configure Package Execution The command-line executable file DTExec is a
fully featured utility with broad parameterization capabilities. You can generate the command
line manually by applying the command parameters to meet the execution circumstance, but
to save time and avoid errors, you can use the command-line builder utility named
DTExecUI. DTExecUI is a visual tool that naturally groups the command parameter options.
The server on which you run DTExecUI must have SSIS installed. To open DTExecUI, type
DTExecUI either from a command prompt or by choosing Start and then Run to open the
Run dialog box. You can open the tool from the Run dialog box or from the command prompt
without specifying the path. To use DTExecUI, follow these steps:
1. Open the Execute Package Utility by executing DTExecUI either by choosing Start and
then Run, and entering DTE xecUI in the Run dialog box, or through a command prompt.
2. On the General property page, select the package for execution so that you can modify a
property on the other pages. In the Package Source drop-down list, select File System, SSIS
Package Store, or SQL Server, depending on where your package is located.
3. After identifying the package location, select the specific package for execution. If your
package is stored in
SQL Server or the SSIS Package Store, you need to specify the connection details to the
SQL Server 2008 server by providing the server name. SQL Server also requires you to
either provide
a user name and password or specify Windows Authentication. All location choices require
that you specify the package in the Package box by clicking the ellipsis button to the right of
the Package box.
4. Next you need to specify how the package should be executed by configuring other
package execution properties. Selecting the various property pages on the left from
Configurations down through Verification will let you override settings such as connections,
logging, and outputs. Table 4-3 describes the execution configuration options.