|
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