What is a SSIS breakpoint and how to configure it?

SSIS breakpoint
To troubleshoot an SSIS Package we use the breakpoints.
Right click on any task in control flow and then select Edit Breakpoint, This will display a Breakpoint window. choose when the execution to be paused(OnPreExecute, OnPostExecute, OnError events). This will be helpful to see the values of a variable at runtime using the output window.

What is a SSIS breakpoint and how to configure it? was last modified: October 1st, 2017 by Justin Antony

What are the components in the Data Flow of SSIS ?

components Data Flow SSIS
1. Source Assistant
2. Destination Assistant
3. Aggregate
4. Conditional Split
5. Data Conversion
6. Derived Column
7. Lookup
8. Merge
9. Merge Join
10. MultiCast
11. OLE DB Command
12. Row Count
13. Script Component
14. Slowly Changing Dimension
15. Sort
16. Union ALL
17. Audit
18. Pivot & unpivot
19. Fuzzy Grouping
20. Fuzzy Lookup
21. Copy Column
22. Export Column
23. Data Mining Query
24. CDC Splitter
25. Character Map

What are the components in the Data Flow of SSIS ? was last modified: October 1st, 2017 by Justin Antony