Yes, I know this is way old but I've used Stairway series before and so I'm just now going through this one as I learn SSIS for work...

First off, thanks for the great series! It's so easy to go through step-by-step and learn the concepts as you go!

Secondly, I am at the part where I'm trying to click the 'New' button next to the Name of the table or the view on the OLE DB Destination Editor window. The problem is, there is no New button! What's up with that?

Thanks and keep up the good work!

EDIT: Nm, I figured it out. I had forgotten to join the Conditional Split first. Ooops!

EDIT2: Sorry, but something I noticed is that even though I have the tasks in the correct order:

TRUNCATE

|

DATA FLOW

|

APPLY STAGED UPDATES

When I view the Progress tab after running it, it appears that Truncate is running last? I could verify this by checking the StageUpdates table after the initial run. It had no records. I assumed the order of task execution was determined by the visual design. What am I missing? thanks!