Figure 1.11 Saving The DTS Package

On this screen we have a mountain of options. so let's go through some of them and look at what they may mean to us here.

1. Run immediately: by default this is checked but we have unchecked it here

2. Schedule DTS package: If we wanted we could schedule the package to execute later on.

3. Save DTS Package: Do you want to save it for later. We have chosen to save it and to SQL Server

If you're wondering what all the options are for where to save a package to then here's an explanation

Save to SQL Server: This saves the package in the msdb database

SQL Server Meta Data Services: This also saves the package to msdb but in the repository tables

Structured Storage File: This saves the package to an actual file that you can then copy anywheren on your file system

Visual basic File: This option is only available in SQl Server 2000 and it saves the package to a VB module file

When you're finished Click Next