1) While designing the package what are the sections we interact with ?

2) What are the control flow tasks you have used ? ( He asked about all the tasks available in BIDS)

3) Is there any task related to database management ? If "Yes" what are they ?

4) What are the dataflow transformations you have used ?

5) Difference between Merge and Mergejoin ?

6) What is the difference between Conditional Split and Multicast ?

7) What is mean by Blocking and Non-blocking Transformations ?

8) Is Mergejoin a Blocking or a Non-Blocking transformation ? Or else its a Semi-Blocking Transformation ?

9) How do we implement loggings in SSIS ?

10) Scenario :-

Suppose i have a shared folder and multiple files in that with different names. I want to create a package and all files are .txt extension.Now, i want to design a package that reads all the data from files and store in a table ? How ?

SSRS :
--------

1) Tellme about the Lifecycle of SSRS Project.

2) How do you create Dashboards in SSRS ?

3) In a report if we want to use sort to sort the data in the database, then which way you prefer ? I mean you write query for your dataset or you prefer SP ? Which one is better ? Why ?

4) What are Cascading Parameters ?

5) Scenario :-

Suppose i have one report and a dataset in that to display the reports but, there is one column in that dataset that requires calculations using one common value and that value is also coming from database.So,by writing complex logic query iam getting that single value in calculations.So,tellme how we can do that in SSRS ?

6) Can we declare variable in SSRS that we can populate using query before report loads? 

7) What are the Data-Driven Subscriptions ?

8) How to display alternate colours for a row in a report ?

9) Scenario :-

Suppose i want to design a report and i have 3 columns in a dataset i.e VehicleType,Salesmonth,Salescount and we have data in that(3 Records). So,i need to get the sum of salescount and totals for that count ? How ?


10) Tellme about Report server Configuration ?