| What is Control Flow in SSIS |
| What is Data Flow in SSIS |
| What is Event handler in SSIS |
| What is Task in SSIS |
| What are limitations of SSIS |
| What are all the SSIS Designer Section? |
| What is Package in SSIS? |
| What is Package Explorer in SSIS |
| What is Connection Manager in SSIS ? |
| What are all the Tasks in SSIS? |
| What are all the Data Preparation Tasks in SSIS? |
| What are all the RDBMS Tasks in SSIS? |
| What are all the Data Flow Tasks in SSIS? |
| The List of Transformation are provided by SSIS in 2008 |
| What are all Script Tasks in SSIS? |
| What are all Work Flow Tasks in SSIS? |
| What is mean by Staging Area in SSIS |
| What is mean by Surrogate Key in SSIS |
| Star Schema and Snowflake Schema in SSIS |
| What is Data Cleansing in SSIS |
| What is Data Staging SSIS |
| Buffering in SSIS |
| Upstream and Down Stream in SSIS |
| Basics of SSIS |
| Architecture of SSIS |
| Container Tasks in SSIS |
| Variables and expressions in SSIS |
| Debugging and Error handling in SSIS |
| Transactions in SSIS |
| Data Viewers in SSIS |
| Precedence Constraints and Error Paths in SSIS |
| Configuration File Types in SSIS |
| Deployment of Package in SSIS |
| SSIS Command-Line-Utilities |
| Data Mining vs OLAP in SSIS |
| How to read Multiple Excel Sheets in one Excel File in SSIS Part-1 |
| How to read Multiple Excel Sheets in one Excel File in SSIS Part-2 |
| How to read Multiple Excel Sheets in one Excel File in SSIS Part-3 |
| How to read Multiple Excel Sheets in one Excel File in SSIS Part-4 |
| Check Points in SSIS |
| What is the RetainSameConnection property and what is its impact? in SSIS |
| What is the Data Path and how is it different from a Precedence Constraint in SSIS |
| What is an SSIS breakpoint? How do you configure it? How do you disable or delete it? |
| What are the different SSIS log providers? |
| How do you enable SSIS event logging? |
| What is the LoggingMode property in SSIS |
| What is event handling in SSIS? |
| How do you write an event handler in SSIS |
| What is the DisableEventHandlers property used for in SSIS |
| What is SSIS validation? |
| Define design time validation versus run time validation in SSIS |
| Define early validation (package level validation) versus late validation (component level validation). |
| What is DelayValidation and what is the significance? |
| How is SSIS runtime engine different from the SSIS dataflow pipeline engine in SSIS |
| How is a synchronous (non-blocking) transformation different from an asynchronous (blocking) transformation in SQL Server Integration Services? |
| What is the difference between a partially blocking transformation versus a fully blocking transformation in SQL Server Integration Services? |
| What is an SSIS execution tree and how can I analyze the execution trees of a data flow task? |
| How would you deploy a SSIS Package on production? |
| What is Execution Tree in SSIS |
| How do you perform data profile in SQL Server Integration Services? What are the different kinds of data profiling in SSIS? |
| What features does the SQL Server Integration Services Import and Export Wizard provide? Is there anything new in this wizard with SQL Server 2008? |
| What an SSIS Lookup Transformation and what new features did SQL Server 2008 deliver? |
| What is Change Data Capture (CDC)? |
| What are the different SQL Server Integration Services Protection Levels and what do they mean? |
No comments:
Post a Comment