Login
Register
All Activity
Questions
Unanswered
Tags
Users
Ask a Question
About Us
985
Questions
779
Answers
Interview Preparation mode
beta
Funny Facebook Status
Enter your email address
All categories
SQL Server Interview Questions and Answers
(197)
SSIS Interview Questions and Answers
(54)
SSRS Interview Questions and Answers
(9)
SSAS Interview Questions and Answers
(29)
.NET Interview Questions and Answers
(186)
Oracle Interview Questions and Answers
(122)
Java Interview Questions and Answers
(32)
UNIX Interview Questions and Answers
(47)
Networking Interview Questions and Answers
(17)
MySQL Interview Questions and Answers
(30)
HR Interview Questions and Answers
(236)
General Interview Questions and Answers
(9)
Other Interview Questions and Answers
(8)
Job Openings
(3)
Greenplum Database Interview Questions and Answers
(5)
Explain what breakpoints are and how you would use them
Nice?
Vote!
asked
1 year
ago
in
SSIS Interview Questions and Answers
by
R
(
19,530
points)
ssis-interview-question
ssis
breakpoint
1 Answer
Nice?
Vote!
Breakpoints put pauses in your package. It’s a great tool for debugging a package because you can place a breakpoint on a task and it will pause the package based on execution events.
A reason in which I have used breakpoints is when I have a looping container and I want to see how my variables are changed by the loop. I would place a watch window on the package and type the variable name in. Set a break point on the container the stop after each iteration of the loop.
answered
1 year
ago
by
R
(
19,530
points)
Related questions
Nice?
Vote!
1
answer
What is a breakpoint in SSIS? How is it setup? How do you disable it?
asked
1 year
ago
in
SSIS Interview Questions and Answers
by
R
(
19,530
points)
ssis-interview-question
ssis
breakpoint
Nice?
Vote!
1
answer
How would you restart package from previous failure point?What are Checkpoints and how can we implement in SSIS?
asked
1 year
ago
in
SSIS Interview Questions and Answers
by
R
(
19,530
points)
ssis-interview-question
ssis
checkpoint
Nice?
Vote!
2
answers
What is a breakpoint in SSIS? How is it setup? How do you disable it?
asked
1 year
ago
in
SSIS Interview Questions and Answers
by
Anand
(
1,440
points)
ssis-interview-question
breakpoint
Nice?
Vote!
1
answer
Can you explain the what the Import\Export tool does and the basic steps in the wizard?
asked
1 year
ago
in
SSIS Interview Questions and Answers
by
R
(
19,530
points)
ssis-interview-question
ssis
Nice?
Vote!
1
answer
Whiteboard techniques you would use to for CDC (Change Data Capture)?
asked
1 year
ago
in
SSIS Interview Questions and Answers
by
R
(
19,530
points)
ssis
ssis-interview-question
cdc