• Andy Leonard (10/18/2012)


    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.

    Hope this helps,

    Andy

    I do see your point, but you do also cover the basics of BIDS, so describing how to create a local instance doesn't seem like it would be beyond the scope of the tutorial. The fact is, I am one of the people who did not know how to create a local instance, and I had to take a break from your tutorial and find another tutorial that described this.

    Perhaps a solution would be to provide a link to a tutorial that covers it?