Design control flow
Determine control flow;
determine containers and tasks needed;
determine precedence constraints;
design an SSIS package strategy with rollback, staging and transaction control;
decide between one package or multiple packages;
determine event handlers;
determine variables;
determine parameters on package and project level;
determine connection managers and whether they are package or project level;
determine the need for custom tasks;
determine how much information you need to log from a package;
determine the need for checkpoints;
determine security needs
Implement package logic by using SSIS variables and parameters
User variables;
variable scope, data type;
implement parameterization of properties using variables;
using variables in precedence constraints;
referring to SSIS system variables;
design dynamic SSIS packages;
package configurations (file or SQL tables);
expressions;
package and project parameters;
project level connection managers;
variables;
implement dynamic package behavior;
configure packages in SSIS for different environments, package configurations
(xmlconfiguration file,
SQLServer table,
registry entry;
parent package variables,
environment variable);
parameters (package and project level);
project connection managers;
property expressions (use expressions for connection managers)
Implement control flow
Checkpoints;
debug control flow;
implement the appropriate control flow task to solve a problem;
data profiling;
use sequence containers and loop containers;
manage transactions in SSIS packages;
managing parallelism;
using precedence constraint to control task execution sequence;
creating package templates;
using the execute package task
Implement data load options
Implement a full and incremental data load strategy;
plan for an incremental update of the relational Data Mart;
plan for loads into indexed tables;
configure appropriate bulk load options;
select an appropriate load technique (SSIS Destination versus T-SQL) and load partitioned tables
Implement script components in SSIS
Create an SSIS package that handles SCD Type 2 changes without using the SCD component;
work with script component in SSIS;
deciding when it is appropriate to use a script component versus a built in;
source, transformation, destination component;
use cases: web service source and destination, getting the error message
Integration Services transactions Required,Supported,NotSupported
Developing a custom task assembly, gacutil
Custom Objects global assembly cache (gac)
Integration Services (SSIS) parameters Project.params
|