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;
8 Cards in this Set
- Front
- Back
|
What are the two ways to create an SSIS package
|
Using the Import\Export Wizard and explicitly from within BIDS.
|
|
|
Give some limitations to using the import\export wizard for creating packages
|
You can specify only one source and one destination in the wizard.
Advanced workfl ow precedence is not available through the wizard. The wizard does not share data sources with other packages. |
|
|
At what level are SSIS Data Sources stored?
|
The Project level, under Data Sources in Solution Explorer. Data Sources are optional.
|
|
|
At what level are SSIS Connections stored?
|
The Package level, in the Connection Managers pane.
|
|
|
What is the benefit of using Data Sources?
|
The connection string can be changed in the Data Sources and any packages using the data sources are updated next time they are opened. This doesn't happen with deployed packages, package configurations must be used instead.
|
|
|
How do you know a connection manager is referencing a data source?
|
The connection manager icon will indicate that it is sharing the data source; four arrows.
|
|
|
What are the three primary control flow objects?
|
Control flow tasks Workflow objects that perform operational-level jobs
Control flow containers Provide a grouping mechanism for tasks and other containers Constraints Let you connect tasks and containers and define execution ordering and precedence |
|
|
What are the three primary containers in SSIS?
|
Sequence Container Lets you organize subordinate tasks by grouping them together,
and lets you apply transactions or assign logging to the container. For Loop Container Provides the same functionality as the Sequence Container except that it also lets you run the tasks within it multiple times based on an evaluation condition, such as looping from 1 to 10. Foreach Loop Container Also allows looping, but instead of providing a condition expression, you loop over a set of objects, such as files in a folder. |
