Microsoft® SQL Server 2012 Unleashed
by Ray Rankins, Paul T. Bertucci, Chris Gallelli, Alex T. Silverstein
The SSIS Designer
The SSIS Designer is extremely easy to use and gives a user the flexibility of editing and manipulating any of the package properties in any order needed, as opposed to the strict sequential order of the SSIS Wizard. After you have mastered all the package concepts, you will find that you will be spending most of your time using the SSIS Designer instead of the wizard.
Because you have already created an SSIS package using the wizard, you can just open a version of this package (which you could have optionally stored in the filesystem as a .dtsx file when we were creating it within the wizard) with the SSIS Designer to see some of the SSIS Designer’s capabilities (see Figure 54.30). So, create a new Integration Services project ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access