some ssis questions

[Inderjeet Singh]

SSIS Assignment

·         How do we implement custom loggings in SSIS. explain in detail.

·         How do we configure checkpoints in SSIS and whats their use.

·         what is the use of delay validation property. Give 2 detailed examples where this can be used.

·         what is the use of SSIS transactions. Explain the different transaction levels. Give an example to show explain the working of transactions.

·         difference between execute process, execute SQL, execute package task.

·         difference between

o   Merge and Merge join

o   Merge and union all

o   Fuzzy grouping and Fuzzy lookup

o   Lookup and Fuzzy lookup

 

·         what is event handler? what is its purpose? give two examples of its use.

·         explain in detail various error handling methods in SSIS.