Bandwidth Monitor
Building a Package in the DTS Designer
By Allan Mitchell
Version 7.0/2000
Level Beginner

Figure 1.12 Set Destination.

Set Dest

In figure 1.12 we get to say whereabouts in the SQL Server database that we chose in the connection information that we want the data to go. We can either choose an existing table or we can create a new one as we do here. When the screen pops up it defaults to a set of values. You are free to change the columns, datatypes and and table name to whatever you want.

Click OK and then Next