Figure 1.7 Choosing The Destination

Now that we've defined where the data is coming from we need to say where it's going to. Figure 1-7 shows where we choose. As you can see it's the same screen as when we chose our text file. The difference here though is we are going to leave it set to a SQL Server connection. You can specify here the name of the server and any logon credentials you need to specify In our example we pass in our NT credentials.

Click Next