dinesh
2010-09-20 09:39:31 UTC
What is foreach-loop container? Give an example of where it can be used.
What is sequence container? Give an example of where it can be used.
What is the difference between Analysis Services processing task & Analysis services execute DDL task?
What is the difference between for-loop container & foreach-loop container?
What are the different parameters or configurations that “send mail task” requires?
Mention few mapping operations that the Character Map transformation supports.
Explain the functionality of: Import Column Transformation and Export Column Transformation
Explain the functionality of: Percentage Sampling transformation
Explain the functionality of: SCD transformation
Explain the functionality of: Union All transformation
What does “Lookup” transformation used for?
What are checkpoints? For which objects we define checkpoint? How to configure checkpoint for a package?
What is the use of “package configurations” available in SSIS?
What are the different ways in which configuration details can be stored?
How to deploy a package from development server to production server?
How to create Integration Services Package Deployment Utility?
How to deploy packages to file system?
How to deploy packages to SQL server? Where in database packages will be stored?
How to set security for a package? Explain the same as per different deployment options.
Explain the architecture of SSIS
Explain the how SSIS engine workflow