August 6, 2013 at 5:47 am
In training kit(70-463) book .I see following question.What's you guys think should be the answer?
As per me its A and C...As per book writer option B is also correct..
2. On which SSIS objects can you set checkpoints to be active? (Choose all that apply.)
a. Data flow task
B. Control flow tasks
C. Sequence container
D. Sort transformation
Pramod
SQL Server DBA | MCSE SQL Server 2012/2014
in.linkedin.com/in/pramodsingla/
http://pramodsingla.wordpress.com/
August 6, 2013 at 6:11 am
Any thought on this guys..
Pramod
SQL Server DBA | MCSE SQL Server 2012/2014
in.linkedin.com/in/pramodsingla/
http://pramodsingla.wordpress.com/
August 6, 2013 at 6:22 am
Why would you think option B is not correct?
The only tasks not supported by checkpoints are for loops and for each loops.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 6, 2013 at 6:29 am
Control flow tasks is not a task or container so not an object.
It's just a name give to collection of tasks and container..
and writer is asking for SSIS objects..
Pramod
SQL Server DBA | MCSE SQL Server 2012/2014
in.linkedin.com/in/pramodsingla/
http://pramodsingla.wordpress.com/
August 6, 2013 at 6:53 am
A control flow task is not a task?
I think you're dwelling too much on semantics here.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 6, 2013 at 8:09 am
As per my understanding yes
A control flow task is not a task..
Pramod
SQL Server DBA | MCSE SQL Server 2012/2014
in.linkedin.com/in/pramodsingla/
http://pramodsingla.wordpress.com/
August 6, 2013 at 12:28 pm
psingla (8/6/2013)
Control flow tasks is not a task or container so not an object.It's just a name give to collection of tasks and container..
and writer is asking for SSIS objects..
Control flow has two object classifications, tasks and containers, appropriately suffixed "Task" And "Container". "Control Flow Tasks" would indicate all control flow objects with the "Task" suffix, all of which checkpoints can be place on.
August 6, 2013 at 1:24 pm
psingla (8/6/2013)
As per my understanding yesA control flow task is not a task..
Ehrm...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 7, 2013 at 6:44 am
Seems there's a little confusion (or else I'm confused).
As I understand it, checkpoint file usage is set in the Control Flow Properties sheet. Then you set the FailPackageOnFailure to TRUE for any objects within the Control Flow where you want a checkpoint file created should it fail.
Frankly, it's a bad question. It depends upon the precise meaning of "set checkpoints to be active". FailPackageOnFailure doesn't set checkpoints active UNLESS checkpoint file usage is Configured in the Control Flow Properties. Conversely, enabling checkpoint file usage is meaningless without setting FailPackageOnFailure for one or more objects in the control flow.
At least, this is how it works from SSIS 2005. Is it different in later versions?
____________
Just my $0.02 from over here in the cheap seats of the peanut gallery - please adjust for inflation and/or your local currency.
August 7, 2013 at 6:51 am
lshanahan (8/7/2013)
At least, this is how it works from SSIS 2005. Is it different in later versions?
I don't think they changed it in later versions.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 7, 2013 at 6:54 am
Just have a look in the properties of all the relevant tasks. The first three, all in the "Control Flow" tab, have the FailPackageOnFailure property which you can set in order to enable the task as a checkpoint (see page 337 of the book). The Sort operation, or indeed anything else in the "Data Flow" tab, does not have that property and cannot therefore be set as a checkpoint.
Hope that helps.
Duncan
Edit: Cross posted with lshanahan on the previous page - it still works as described in that post.
August 7, 2013 at 8:22 am
Thanks Koen and Duncan
Pramod
SQL Server DBA | MCSE SQL Server 2012/2014
in.linkedin.com/in/pramodsingla/
http://pramodsingla.wordpress.com/
Viewing 12 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply