1. What is ETL
2. What are important components of ETL Tool
3. Which ETL Tool you have used as ETL Developer
4. Which version of SSIS you have worked
5. What is DTS and how it is different from SSIS
6. What are few different features you have in SSIS 2008 and those were not available in SSIS 2005
7. What features are new in SSIS 2012 those were not in SSIS 2008
8. What is difference between Control Flow and Data Flow in SSIS
9. What is parallel execution in SSIS and how many Data Flow Tasks a package can run in parallel
10. What is MaxConcurrentExecutables property on Package level
11. What is Engine Thread property of Data Flow
12. What is Precedence Constraints in SSIS and where you have used them and why
13. What is difference between Success and Completion value of Precedence Constraint
14. What is DelayValidation properties of Data Flow Task , Why we need to use this property
15. What is RetainSameConnection Property on Connection, Why we use that
16. If we create temp table in SSIS Package and want to use further in other Tasks, which properties we need to set to be able to use temp table.
17. What is data Viewer in SSIS, Is data viewer available in Control Flow or Data Flow
18. I am running my package for debugging, I do not want to load data into any destination, which transformation I can use for test purpose as destination without writing data to anywhere
19. What is difference between checkpoint and breakpoint in SSIS
20. Will my package run successfully by using SQL Server Agent if I have data viewers enabled and breakPoint
21. What are different ways to execute your SSIS Package, Can I run SSIS Package by using a Stored Procedure
22. What type of deployment available for SSIS Package, explain all
23. What is difference between Package deployment and Project Deployment
24. Which version of SSIS track versions of SSIS Package deployed to Server
25. To run your SSIS Package, the Integration Services Server and SQL Server should be installed on same server, Is this correct statement?
26. What are different ways to run your package on schedule
27. What are Event Handlers in SSIS , On which Events you can run the event handler part, Name few of the Events available
28. Let’s say you have configured Event handler to send an email on error for data flow inside For each Loop, If error occurred in data flow you will get multiple emails, why is that? How we can handle those series or email coming for one error
29. How do you debug your package
30. Explain important steps for performance tuning of your SSIS Package
31. If your package is scheduled to run every night at 10 PM. If package fails in production , where will you start to look for error
32. You have created a variable in SSIS, You used that variable in Data Flow task in Row Count transformation, if you want to display or see the value of variable after Data Flow execution how will you do that
33. You are looking at Control Flow Item and you cannot find Execute SQL task, how will you bring it back to Control Flow Items.
34. Your company is using some third party transformations and task, you need to add them to Control Flow Item and Data Flow Items , how will you do that
35. What are Attunity Drivers and why do we use them with SSIS
36. If you do not want to use Slowly Changing Transformation, Which T-SQL statement can help you to load SCD type table in one statement( insert, update, delete)
37. What is Annotation, Is it only available in Control Flow Pane or available in other Panes as well
38. Let’s say we have two Execute SQL Tasks in Sequence container, If any of them fail we want to roll back transaction. What setting we need to configure to achieve this.
39. What is TransactionOption property at Package level, Is this property only available on package level or It is also available on Container level,Task level
40. Can you create SSIS Package without using BIDS
41. You have excel file and you want to clear first cell of sheet1, which task you will use to do that
42. A third party software is available that you need to execute by using SSIS, which task can be used to run .EXE file
43. You need to load 500 million records in table; Table has cluster and non-cluster indexes already created. What will be your approach to load data
44. What are Asynchronous and Synchronous data flow components
45. What are Non-blocking, Semi-blocking and Fully-blocking components in SSIS?
46. What is Balanced Data Distributor( BDD)
47. What is Error Output? Can you redirect rows from Sources, Transformations and Destinations in SSIS?
48. If you need to check If File exists in Folder which Tasks you will use to find out that in SSIS
49. Let’s way you have created an Excel File by using Excel Destination. If you have to make the Header row bold, how you will do that in SSIS?
50. If you need to send HTML email, Can you use built in Send Mail Task? What other options you have?
51. If you are using SQL Server Log Provider, Can you make the SQL Server connection dynamic?
52. If you need to watch a directory for a specific file to be added which Task you will use?
53. What is For-each Item Enumerator in For-each loop and where would you need to use this?
54. If you need to move a file and rename as the same time how will you do that?
55. Which Package property will help you to encrypt packaged to restrict access to the contents of a package?
2. What are important components of ETL Tool
3. Which ETL Tool you have used as ETL Developer
4. Which version of SSIS you have worked
5. What is DTS and how it is different from SSIS
6. What are few different features you have in SSIS 2008 and those were not available in SSIS 2005
7. What features are new in SSIS 2012 those were not in SSIS 2008
8. What is difference between Control Flow and Data Flow in SSIS
9. What is parallel execution in SSIS and how many Data Flow Tasks a package can run in parallel
10. What is MaxConcurrentExecutables property on Package level
11. What is Engine Thread property of Data Flow
12. What is Precedence Constraints in SSIS and where you have used them and why
13. What is difference between Success and Completion value of Precedence Constraint
14. What is DelayValidation properties of Data Flow Task , Why we need to use this property
15. What is RetainSameConnection Property on Connection, Why we use that
16. If we create temp table in SSIS Package and want to use further in other Tasks, which properties we need to set to be able to use temp table.
17. What is data Viewer in SSIS, Is data viewer available in Control Flow or Data Flow
18. I am running my package for debugging, I do not want to load data into any destination, which transformation I can use for test purpose as destination without writing data to anywhere
19. What is difference between checkpoint and breakpoint in SSIS
20. Will my package run successfully by using SQL Server Agent if I have data viewers enabled and breakPoint
21. What are different ways to execute your SSIS Package, Can I run SSIS Package by using a Stored Procedure
22. What type of deployment available for SSIS Package, explain all
23. What is difference between Package deployment and Project Deployment
24. Which version of SSIS track versions of SSIS Package deployed to Server
25. To run your SSIS Package, the Integration Services Server and SQL Server should be installed on same server, Is this correct statement?
26. What are different ways to run your package on schedule
27. What are Event Handlers in SSIS , On which Events you can run the event handler part, Name few of the Events available
28. Let’s say you have configured Event handler to send an email on error for data flow inside For each Loop, If error occurred in data flow you will get multiple emails, why is that? How we can handle those series or email coming for one error
29. How do you debug your package
30. Explain important steps for performance tuning of your SSIS Package
31. If your package is scheduled to run every night at 10 PM. If package fails in production , where will you start to look for error
32. You have created a variable in SSIS, You used that variable in Data Flow task in Row Count transformation, if you want to display or see the value of variable after Data Flow execution how will you do that
33. You are looking at Control Flow Item and you cannot find Execute SQL task, how will you bring it back to Control Flow Items.
34. Your company is using some third party transformations and task, you need to add them to Control Flow Item and Data Flow Items , how will you do that
35. What are Attunity Drivers and why do we use them with SSIS
36. If you do not want to use Slowly Changing Transformation, Which T-SQL statement can help you to load SCD type table in one statement( insert, update, delete)
37. What is Annotation, Is it only available in Control Flow Pane or available in other Panes as well
38. Let’s say we have two Execute SQL Tasks in Sequence container, If any of them fail we want to roll back transaction. What setting we need to configure to achieve this.
39. What is TransactionOption property at Package level, Is this property only available on package level or It is also available on Container level,Task level
40. Can you create SSIS Package without using BIDS
41. You have excel file and you want to clear first cell of sheet1, which task you will use to do that
42. A third party software is available that you need to execute by using SSIS, which task can be used to run .EXE file
43. You need to load 500 million records in table; Table has cluster and non-cluster indexes already created. What will be your approach to load data
44. What are Asynchronous and Synchronous data flow components
45. What are Non-blocking, Semi-blocking and Fully-blocking components in SSIS?
46. What is Balanced Data Distributor( BDD)
47. What is Error Output? Can you redirect rows from Sources, Transformations and Destinations in SSIS?
48. If you need to check If File exists in Folder which Tasks you will use to find out that in SSIS
49. Let’s way you have created an Excel File by using Excel Destination. If you have to make the Header row bold, how you will do that in SSIS?
50. If you need to send HTML email, Can you use built in Send Mail Task? What other options you have?
51. If you are using SQL Server Log Provider, Can you make the SQL Server connection dynamic?
52. If you need to watch a directory for a specific file to be added which Task you will use?
53. What is For-each Item Enumerator in For-each loop and where would you need to use this?
54. If you need to move a file and rename as the same time how will you do that?
55. Which Package property will help you to encrypt packaged to restrict access to the contents of a package?
No comments:
Post a Comment