joresnik (10/16/2012)
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?
Hi Joresnik,
While I understand your point, I disagree. This series is focused on learning to develop data integration solutions with SSIS.
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.
A backup of the AdventureWorks database I use may be found here.
Hope this helps,
Andy
Andy Leonard, Chief Data Engineer, Enterprise Data & Analytics