For this example, check the options for Run Immediately, Save SSIS Package, and File System.
This collection of options will execute the package and save it as a .dtsx file to your computer. You
learn more about where to save your SSIS packages later in this chapter. Note that if you save the
package to SQL Server or to the file system, you’re saving the package with the Package Deployment
Model. We’ll discuss more about the package deployment model in Chapter 22.
In this screen, you’re also asked how you wish to protect the sensitive data in your package. SSIS
packages are essentially large XML files behind the scenes, and encryption of sensitive data, such as
passwords, is critical to ensuring that no one sees that information by opening the XML manually.
Again, you learn more about this later in this chapter, so for now just change the Package Protection
Level property to “Encrypt sensitive data with password” to protect your sensitive data with a
password, and give the dialog a password (as shown in Figure 2-5).
You are then taken to the Save SSIS Package screen, where you can type the name of the package
and the location to which you want to save it (see Figure 2-6).