SSIS

1. SSIS
2. ·         What is deployement,what are the ways deployment do,suppose I have .dtsx file i need to deploy in production server how to do
3. ·         What is logging
4. ·         What is package configuration in package config what is environment variable and after creating the package I need to move test environment
5. ·         I have package in dev environment working successfully but in test environment getting errors what the ways you solve the problem
6. ·         I have 10 packages I need to run 2,4,6 packages in one time and 3,7,9 need to run another time how to set
7. ·         I have 1000 folders in my remote system I need to read only .txt files and load in to datawarehouse destination
8. ·         I have 100 files in my remote system I need to read 10 files for one time and remaining will be certain time
9. ·         What are event handlers in ssis how it will works can you give me one example
10. ·         What are breakpoint in ssis
11. ·         What is the diff b/w term extraction and termlookup
12. ·         What is the difference b/w lookup and fuzzylookup
13. ·         What is diff b/w merge and union all
14. ·         What is the diff b/w multicast and union all
15. ·         What is pivot and it is normalized and de normalized
16. ·         What is unpivot difference b/w pivot and unpivot
17. ·         What is SCD type 2
18. ·         What is diff between sqlserver destination and oledb destination
19. ·         What is diff between merge and merge sort
20. ·         What is dataflow/controlflow/workflow
21. ·         What are dataviewers /breakpoints
22. ·         I have 1 lack records in my remote system in 2000 record will be failed so I need to trace the error how will you solve the problem
23. ·         What are sequence container
24. ·         What are containers available in ssis
25. ·         Have you run stored procedure in SSIS
26. ·         Have you work ftp task in ssis
27. ·         What is manifestfile in ssis
28. ·         What is difference between SSIS/DTS
29. ·         What is difference between SSIS 2005/SSIS 2008
30. ·         In my source .tx file contains firstname,lastname ,loc columns I need in my destination fullname(firstname+lastname) how to do?
31. ·         What diif forloop container/foreach container