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:

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.

ben.kimball (10/16/2012)

---

What version of AdventureWorks are you using? This example fails with AdventureWorks for SQL Server R2.

Person.Contact doesn't exist anymore, it's been broken into separate tables for EmailAddress, etc.

ben.kimball (10/16/2012)

---

Oops, just noticed a previous reply about the same thing.

However, in the link in your reply, it just takes me to Step One of the SSIS Stairway. I still can't make the connection between what you say in Step Two and its reference to Step One.

What exactly was supposed to have been done in Step One to be ready for Step Two. Nothing looks like an "Action Item" in Step One.

joresnik (10/16/2012)


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.

ben.kimball (10/16/2012)

---

OK, I am fully confused. I created a "First_SSIS_Project" project, and now have an empty solution that looks like:

First_SSIS_Project
- Connections
- Queries
- Miscellaneous

Now what do I do?

Sorry, remember, I am completely inexperienced with SSIS, so even absolute beginner steps are needed with such things.