SSIS Interview Questions

Session 2

• Explain SSIS architecture ?
• Difference between DTS & SSIS package (Explain briefly)
• What is the use of deployment and explain the steps of deployment process?
• what is 2012 deployment model ?
• what are Package parameters?
• Different between 2012 & 2014 BI Tool, explain each and every thing
• SSIS Synchronous and Asynchronous transformation ?
• What is CDC and explain about CDC?
• Explain about Checkpoints and break points ?
• Difference between raw file source and destination
• Package security types ?
• What are the types of transformations in SSIS (Like fully , partial & no blocking)?
• What are fully blocking transformations & Partial ?
• Encryption mechanism in SSIS
• How to send the Encryption files to clients in SSIS
• CLR Program
• Error Exceptions in SSIS
• Lookup and different types of caches and why we use it ?
• Knowledge on Migration in SSIS?                                          More ....