A couple things I think need clarification:
Figure 12
Click the New button here to define a new data connection using the Connection Manager Editor. Earlier I wrote the connection managers handle things like database engine instance and database name. This is where we configure those items:
I believe you mean to say "Earlier I wrote that the connection....." Amazing how missing one word can make a sentence confusing.
Figure 13
The server name can be typed into or selected from the Server Name dropdown. Once the server name is configured, SSIS actually connects to the server and retrieves a list of databases. You can enter or select the database in the “Select or enter a database name” dropdown. In this case, I connected to the (local) instance of SQL Server and selected the AdventureWorks database.
I think you skipped something here. What if a person new to this does not have a local instance of SQL server created? Will they know how to do this?
Also, unless I'm misunderstanding something, Persons.Contact seems to be a pre-made table, and I don't see you referencing it anywhere until it's being used. When I follow the steps of the tutorial, that table is not associated with my project.