Reading...
Play button
Play button
Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
45 Cards in this Set
- Front
- Back
|
What is the SSIS service?
|
A Windows service named SQL Server Integration Services 10.0 which runs an executable file called MsDtsSrve.exe
|
|
|
How do you configure the startup requirements and the serivce account for SSIS Service?
|
Using the SQL Server Configuration Manager
|
|
|
How do you connect to the service once it is started?
|
Using SSMS--in the Connect To Server window change the server type to Integration Services
|
|
|
What does the "Stored Packages" folder store?
|
Files that are stored in the package store location
|
|
|
Does SSIS support instances?
|
No
|
|
|
What are the two ways to configure the SSIS service in a clustered environment?
|
Install the SSIS service independent from the cluster resources
Integrate the SSIS service in a cluster group |
|
|
What do you have to do if you install the SSIS service independent from the cluster resources and you want to centralize all your packages in SQL Server?
|
You need to change the MsDtsSrvr.ini.xml file so the <serverName> element refers to a sepcific server and instance
|
|
|
What do you have to do if you install the SSIS service in a cluster group?
|
Follos the process detailed in "Configuring Integration Services in a Cluster Environment"
|
|
|
What are the two most important reasons for securing SSIS?
|
Protect connection information and schema information
|
|
|
What are the three ways to limit access to packages?
|
Apply SQL Server security roles to any packages that have been deployed to the SQL Server MSDB database with SQL logins or window groups
You can employ security encryption by using the package protection level for all or some of the data you can use file-level security |
|
|
What do the read and write roles entail?
|
Read actions focus on viewing and executing packages
write actions apply to moving packages in and out of msdb without executing the packages |
|
|
What are the Built-in SSIS roles in msdb?
|
db_ssisadmin
db_ssisltduser db_ssisoperator Windows admin |
|
|
What are the read/write actions associated with db_ssisadmin?
|
Read--View all packages, execute all packages, export all packages, execute ll pacakages in SQL Server Agend
Write--Delete all packages, chall all package roles, import packages |
|
|
What are the read/write actions associated with db_ssisltduser?
|
Read--View user's packages, execute user's packages, export user's packages
write actions--delete user's packages, change user's package roles, import packages |
|
|
What are the read/write actions associated with db_ssisoperator?
|
Read--View all packages, execute all packages, export all packages, execute all packages in SQL Server Agent
Write--none |
|
|
What are the read/write actions associated with Windows admin?
|
Read--View execution details of currently running packaged
write--Stop currently running packages |
|
|
What does a package's ProtectionLevel property do?
|
It encrypts the package definition information that resides in the underlying XML file
|
|
|
What does a package's PackagePassword property do?
|
It's used when the protecionLevel requires encrypting metadata in the package with a password
|
|
|
What is the default ProtectionLevel?
|
The default ProtectionLevel is EncryptSensitiveWithUserKey which encrypts sensitive information (like a connection with a password) so only the package author can view it. In this case others have to know the connection password to run your pacakage.
|
|
|
What are options are available for ProtectionLevel?
|
DontSaveSensitive
EncryptAllWithPassword EncryptAllWithUserKey |
|
|
What happens when you select ServerStorage as a ProtectionLevel option?
|
Nothing in the package definition is encrypted--instead the entire package is protected by using a SQL server database role. This option isn't supported when a pacakage is saved to the file system.
|
|
|
What tool does SSIS use to encypt data?
|
Microsoft Data Protection Applicatoin Programming Interface (DPAPI)
|
|
|
What will happen if you deply SSIS packages to a new server with the EncryptSensitiveWithUserKey protection level?
|
Connection passwords will not be decrypted and the package execution will fail.
|
|
|
What ProtectionLevel should you use if all your connections use Windows Authentication?
|
DontSaveSensitive
|
|
|
Are you permitted to save sensitive information in clear text in a package file stored in the file system?
|
No
|
|
|
What are the encryption level numeric indicators?
|
0 = DontSaveSensitive
1=EncryptSensitiveWithUserKey 2=EncryptSensitveWithPassword 3=EncrytAllWithPassword 4=EncryptAllWithUserKey 5=SQLServerStorage |
|
|
How would you encrypt MyPackage.dtsx with the pasword EncPswd?
|
dtutil.exe /file MyPackage.dtsx /encrypt file
MyPackage.dtsx 3 EncPswd |
|
|
What are the two ways of executing packages?
|
Programatically using the SSIS object model
Using the command-line tools |
|
|
What are the two classes within the Microsoft.SqlServer.Dts.Runtime namespace that can execute packages?
|
The application class (which includes the LoadFromSQLServer method nad the LoadPackage method
The Package class which includes and execute method |
|
|
What is the DTExecUI?
|
DTExecUI is a visual tool that naturally groups the comman paramater options
|
|
|
What does the DTExecUI Execution Configuration page called General do?
|
Specifies the package location and name on this property page
|
|
|
What does the DTExecUI Execution Configuration page called Configurations do?
|
In addition to the configurations alrady defined in the package, you can add XML configurations to a package at execution time through this property page, which will be added to the existing configurations.
|
|
|
What does the DTExecUI Execution Configuration page called Command Files do?
|
The DTExec.exe paramaters can be stord in a separate file, and the Command Files properties let you specify the text file that will contain the paramaters
|
|
|
What does the DTExecUI Execution Configuration page called Connection Managers do?
|
For the selected package, the connections can be overwritten at run time with new connectoin information. Select the connections to overwrite, and then manually alter the connection string.
|
|
|
What does the DTExecUI Execution Configuration page called Execution Options do?
|
The execution options property page allows advanced details for the package execution, including
Validate Package Without Executing Maximum Concurrent Executables Enable Package Checkpoitns Browse to Checkpoint FIle Override Restart Options Restart Options |
|
|
What does the DTExecUI Execution Configuration page called Reporting do?
|
The reporting properties define the informaiton returned to the command-line output. The selected events determine the level of information returned.
|
|
|
What does the DTExecUI Execution Configuration page called Logging do?
|
Log providers can be added at run time
|
|
|
What does the DTExecUI Execution Configuration page called Set Values do?
|
The Set Values properties let you override package properties, includign package variables.
|
|
|
What does the DTExecUI Execution Configuration page called Verification do?
|
On this property page you set verification options that allow a package to run, using the following: Execute only signed packages
verify package build build verify pacakge ID package ID Verify Version ID Version ID |
|
|
What does the DTExecUI Execution Configuration page called Command Line do?
|
The command line property page shows the command line that will be passed to DTExec.
|
|
|
What's the difference between the /Dump and the /DumpOnError switch?
|
The /Dump creates the dump when a specified event occurs, while the /DumpOnError creates a logging dump file if an error occurs
|
|
|
Do packages execute where they are stored or where the DTExec is run?
|
Where the DTExec is run
|
|
|
What is SQL Server Agent?
|
SQL Server Agent is a Windows service that can schedule and execute jobs. You can schedule jobs to run on a specific schedule or in response to a specific event or manually.
|
|
|
What is the default status for SQL Server Agent?
|
Off, so you have to o into the service properties in the Sql Server 2008 Services Containter
|
|
|
If you have a pacakge for which a variable must be updated at the start of execution, what methods are available to you?
|
Variable can be updated at execution by using a configuration or by using the Set Value command-lin paramate, where the property path is typed as \Package.Variables[user:: strUserName].Value and the value is passed in
|
