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.
Bạn đang xem 6. - THE REAL MTCS SQL SERVER 2008 EXAM 70 432 PREP KIT P77 PPSX