Which Version of SSIS Have You Worked With?

SSIS

What is Business Intelligence ( BI) ?
Which version of SSIS have you worked with?
What additional features are available in SSIS 2012 that were not in SSIS 2008?
What is the difference between Control Flow and Data Flow in SSIS?(
What is parallel execution in SSIS, and how many Data Flow Tasks can a package run in parallel?(
What is the MaxConcurrentExecutables property on a Package level?(
What is the Engine Thread property of Data Flow Task?
What are the Precedence Constraints in SSIS, and where and why have you used them?(
What is the difference between the Success and the Completion value of Precedence Constraint?(
What is the DelayValidation property of Data Flow Task? Why does one use this property?(
What is RetainSameConnection Property on Connection Manager in SSIS Package? Why is it used?(
If we create a temp table in SSIS Package and want to use it in other tasks, which properties do we need to use?(
What is data Viewer in SSIS? Is data viewer available in ControlFlow or Data Flow?(
I am running my package for debugging and I do not want to load datainto any destination. Which transformation can I use to ensure that the data goes nowhere else?(
What is the difference between Checkpoint andBreakpoint in SSIS?
Will my package run successfully by using SQL Server Agent if I have data viewers and Breakpoint enabled?
What are different ways to execute your SSIS Package?Can I run a SSIS Package by using a Stored Procedure?(
What types of deployment are available for a SSIS Package? Explain all.(
What is the difference between Package Deployment and Project Deployment?(
Which version of SSIS can track versions of a SSIS Package deployed to the Server?(
To run your SSIS Package, the Integration Services Server and SQL Server should be installed on the same server. Is this a correct statement?
What are the different ways to run your SSIS package on a schedule?(
Let’s say you have configured Event Handler to send an email to report an error for Data Flow Task inside For EachLoop.If error occurred in a data flow task, you will get multiple emails. Why is that? Howwe can prevent those series of emails coming for one error?
How do you debug/troubleshoot your SSIS package?(
Explain the important steps for performance tuning of your SSIS Package.
If your package is scheduled to run every night at 10 P.M., and the package fails in production, where will you begin your search for the error details?(
You have created a variable in SSIS, and you have used that variable in Data Flow Task in Row Count Transformation. If you want to display or see that value of variable after Data Flow execution, how will you do that?(
You are looking at Control Flow Item, and you cannot find Execute SQL task. How will you bring it back to Control Flow Items?(
Your company is using some third party transformations and tasks, and you need to add them to Control Flow Item and Data Flow Items. How will you dothat?
What are Attunity Drivers and why do we use them with SSIS?(
If you do not want to use Slowly Changing Transformation, WhichT-SQL statement can help you to load an SCD type table in one statement?
What is Annotation? Is it only available in Control Flow Pane oravailable in other Panes as well?(
Let’s say we have two Execute SQL Tasks in a Sequence container. If any of them fail, we want to roll back the transaction. How can we achieve this?
What is a TransactionOption Property at the Package level? Is this property only available at the package level, or it is also available at the Container Level or Task level?
Can you create an SSIS Package without using BIDS or SSDT?(
You have an excel file and you want to clear the first cell of sheet 1, which task will you? (Answer : To perform this you have to use Script Task)
A third-party software is available that you need to execute by using SSIS. Which task can be used to run EXE file?(
You need to load 500 million records in a table; this table has cluster and non-cluster indexes already created. What will be your approach to load the data?
What are Asynchronous and Synchronous data flow components?
What are Non-blocking, Semi-blocking and Fully-blocking components in SSIS?
What is Balanced Data Distributor( BDD)?
What is Error Output? Can you redirect rows from Sources,Transformations and Destinations in SSIS?(
If you need to check that a file exists in a folder, which task(s) will you use?(
Let’s say you have created an Excel File by using Excel Destination. If you have to make the Header row bold, how will you do that in SSIS?(
If you need to send an HTML email, can you use the built-in Send MailTask? What other options do youhave?(
If you need to watch a directory for a specific file to be added, which Task will you use?(
What is For-each Item Enumerator in For-each Loop Container? Why would you use it?(
If you need to move a file and rename it at the same time, how will you do that?(
We have received Excel Source File with multiple sheets but with the same meta data. How will you design your package to load all of the sheets to same table?
You have redirected records due to Truncation or data conversion errors from some transformation. How will you find which column created the error? How do you detect the name of the column?(
You have created different types of SSIS Packages. How do you determine all the variable names, connection managers, logging information or expression used in those Packages?
You have received a big Excel or flat file, but you only want to load the first 100 records in a table. How will you do that?(
You have received an Excel Source file, but the first 10 rows have only company information; actual data starts from Row 11. How will you skip the first 10 rows and start reading from row 11?(
If you need to read only one cell value from an Excel file in SSIS, which task will you use?(
You are extracting data from a view. The definition of View can change anytime. We want to load this data to an Excel file by using this view. How do you create a dynamic package so that you don't have to re-do the mapping?(
You are running different SSIS Packages on your server. How do you determine how much time each package took for execution?(
Is it possible to run the SSIS Package from Excel by using Excel Macros?(
If you need to purge old files, which tasks will you use in your SSIS Package ?
After developing your SSIS Package, you want to write a technical document. What are important contents would you like to cover in that document?(
There are so many files in our folders, we want to save the file name, file created date and size of each file in an Audit table. Which tasks will you use to do that?(
We have .sql files sitting in a folder, and we want to execute all of them. How can you run them by using SSIS Package?(
We have a table which contains different types of files that we want to export to folder. Which transformation do we need to use?(
There are 100 files in a directory. All have the same structure. You need to load the most recent file to table. How will you do that?(
Is backwards compatibility possible for an SSIS Package? In other words, if you have created your SSIS Package in SSIS 2008, can you downgrade to SSIS 2005?(
What is the difference between Package Level Connection Manager and Project Level Connection Manager?(
How would you get the oldest file from a Folder?(
How would you find which SSIS Packages are used by SQL Server Agent Jobs?(
How would you find out if a Stored Procedure is used in SSIS Package?(
How would you find and replace object name in SSIS Package or SSIS Packages in Solution?(
How would you create Load Summary Email logic in SSIS Package?(
You have different folders sitting in Parent Folder. You want to delete old folder which are older than 7 days. How would you do that in SSIS Package?
How would you make your SSIS Package dynamic?(
Sometime when you execute your SSIS Package, You get an error " File is used by another process". Why did you get this error? and How can you avoid this error?(
How would you implement data validation in your SSIS Package?
What are the best practices to test SSIS Package?
We can load data from one database tables to another database tables by using TSQL, Why do we use SSIS instead ?
How would you change the value of variable in SSIS Package during debugging to test different scenarios?(
Is it possible to save Stored Procedure Output Parameter value to SSIS variable ?
What is the purpose of naming convention in SSIS ?(
Which Control Flow Task you will use if you need to convert excel file to csv file?(
You need to delete Top N Rows from Flat File, How would you do that?(
You have different SSIS Packages in one of the folder, How would you find the version of each SSIS Package?(
Your SSIS Package consist of multiple Data Flow Tasks. You need to execute only first 2 Data Flow Task, How would you do that?(
Explain an example where you had to build your Query dynamically in SSIS Package and how did you do that?
If you have to perform Case Statement on one of the column data, Which Transformation would you use and how will the expressions look like?(
If you need to copy all the tables from a SQL server Database to flat files, how would you do that?(
How would you convert Month Name into Month Number in SSIS Package?(
How would you convert Month Number into Month Full Name and Month Short Name in SSIS Package?(
You receive different text files to load in a database. After Loading into database you want to move them to different folders depending upon the date part in the file name, How would you do that?
How would you create monthly archive folders in SSIS Package to archive your loaded files?
(
How would you save file names from different folders in a SQL Server Table?(
When you are working as SSIS developer , why it is important to know C# or Visual basis language?(
Do you think every task should be done by using components of ETL Tool or better to use combination of SQL Objects ( such as Stored Procedure, Queries etc.) with components available in ETL Tool? (
You just joined a company as ETL Developer, You hear this term "Staging Database" from your ETL colleagues. What does this term mean to you?(
What is ODS Database? What it has to do with you as ETL Developer?
What is the difference between Full Load and Incremental Load? What is your approach to load data into Staging Database?(
What techniques do you use to perform incremental Load in SSIS or as ETL developer?
How would you generate multiple flat files from SQL Server partition table? The SSIS Package should generate a file per partition?
You have received 500 pipe delimited files, each one has different meta data. How would you load all of them to SQL Server Database. Each file should be loaded to its own table?
How would you load multiple excel files with same structure to SQL Server Table and Archive them after adding datetime to them?(
How to Create Excel file with Date-time on Each Package Execution in SSIS Package?
How to Load Multiple Sheets to a SQL Server Table in SSIS Package?
How to Load Data Excel File to SQL Server Table and Solve Data Conversion Issues?
How to Load Multiple Sheets From Multiple Excel Files to Different Tables in SSIS Package?
How to Load Data to Pre-Formatted Excel Sheet (Excel Report) in SSIS Package?
Let's say you have given Full Address column in Excel Source file such as 'My Street Address,MyCity,MyState,MyZip'. How would you create Multiple Columns such as Street Address,City,State and Zip from FullAddress column in SSIS Package?
How to return Output parameter value of Stored Procedure from OLE DB Command Transformation and save value to Output Column?
How would you find our if a character occurs more than one time in column value and redirect that row in SSIS Package?
What is the Max size of SQL Statement that you can use in Execute SQL Task Query Editor?
If you have to save single value to a string variable from a SQL Server table, Which Task will you use it?
If you need to insert some variable values from SSIS Package to a SQL Server Table, Which Task will you use it and how to Map the Variable to it?
If once of your Stored Procedure is returning a value, How would you execute that Stored Procedure in SSIS Package and save the value to a variable?
If you need to validate File name against definition table before loading , which Tasks will you use to perform that in SSIS Package?
Explain a scenario in which you have used the Execute SQL Task with Full Result Set?
Let's say you have saved update/Delete count from Execute SQL Task to variables, How can you write these variables into Flat File?
How would you load only new files to SQL Server table and Reject already loaded files in SSIS Package?
You are executing multiple stored procedures in Execute SQL Task in SSIS Package, Package is running from long time. If your Manager ask which stored procedure is currently running or how many time each one take to complete, How will you get that information?
You have multiple IF Statements that you want to execute in Execute SQL Task. But in Condition should use a variable value. How can you replace the IF Statement condition by using variable from SSIS Package?
In OLE DB Command Transformation , when we use parameters, it gives us Param_0, Param_1 etc. How can we get proper name for these parameters?
Can we use Sub Query with parameters in OLE DB Command Transformation, How does the mapping come up for Sub Query Parameters?
Can we use Common Table Expressions with input parameters in OLE DB Command Transformation in SSIS Package?
Is it possible to call multiple statements such as insert/update/Delete with parameters in OLE DB Command Transformation in SSIS Package?
Can you Map a input column to multiple Parameters of Stored Procedures in OLE DB Command Transformation in SSIS Package?
Is it possible to make changes in SQLCommand of OLE DB Command Transformation dynamically by using Variable/s in SSIS Package?
We need to load multiple text files to SQL Server table, but the list of columns can be different for each of the file. How to load all the files in this scenario?

SSRS

What is SSRS ?
When SSRS was introduced in Market and What Versions are available?
What is Shared Data Source in SSRS(SQL Server Reporting Services) ?
What is Shared Dataset in SSRS(SQL Server Reporting Services) ?
What is Embedded data source and how is it different from Shared Data Source?
What is difference between Data Source and DataSet in SSRS?
What type of SSRS Reports Can and Can't be created by using Report Wizard?
Can you create parameter reports by using SSRS Report Wizard?
What are the steps/stages of SSRS report processing?
How would you Edit already deployed SSRS Report?
What is Report Manager? Explain the function of Report Manager.
Which tool can be used by the Business Users to create their own reports?
Which delivery/export options are allowed in SSRS?
How to display all the records on one page in SSRS?
What are the different ways to sort your reportdata? What is interactive sort?
How to display data on single tablix from two datasets in ssrs report by joining on single column? What is Lookup Function in SSRS Report?
How to display data on single tablix from two datasets in ssrs report by joining on Multiple Columns? What is Lookup Function?
If you want to display header on each of newpage, how would you do that?
What are seven rendering extensions available inSSRS?
What is page break in SSRS Report?
If you want to display only X rows per page inSSRS, how will you achieve that?
You have report that has multiple pages withdifferent