SAVE AND RUN THE PACKAGE. YOU CAN RUN AND/OR SAVE THE INFORMATION Y...

6. Save and Run the Package. You can run and/or save the information you

just configured in the wizard. If you choose to save it, the wizard will

create an SSIS package and save it based on the options you choose in the

wizard. You can save it as a .dtsx file in the file system (this is one of those

XML package files mentioned earlier), or you can save it as data into the

MSDB database on a SQL Server instance. When saving it, you also get to

choose how and at what level to encrypt the package. If you choose to

save it, the next screen in the wizard will prompt you for the location to

which you want to save the package.

The preceding list of steps is a generalization of the process you use as you go

through the wizard. You should run through the wizard a few times, selecting

different types of sources and destinations each time so that you can get a feel for

how the wizard works in each situation.

Again, it is probably better to have you try the wizard than to just fill this book

up with screen shots. So give the following exercise a try.