Database Reference
In-Depth Information
the GettING StarteD (SSIS) WINDOW
in SQL 2012, SSiS has a new start-up window that provides helpful links to videos and articles (Figure
2-27
).
At some point, you may want to view these videos, but most of the time you can simply close this window.
Figure 2-27.
The new Getting Started (SSIS) window
You can close this window each time you make a new SSiS project, or you can click the “Always show in
new project” checkbox to change this behavior. if you want to see this window at another time, there is a
getting Started menu item under the SSiS main menu that displays it again.
An SSIS package file is essentially a text file formatted as in the XML language. While this file can be
manually programmed, you likely will let Visual Studio do the coding for you. To use this feature, you drag and
drop items from the SSIS Toolbox onto a package's design surface. This act invisibly writes your XML code for
you. (We will elaborate on this in a moment.)
As of SQL 2012, SSIS now includes a dedicated Visual Studio Toolbox in addition to the standard Visual
Studio Toolbox (Figure
2-28
).
Each item in the Toolbox represents a set of SSIS commands. For example, Figure
2-28
shows a Data Flow
task icon and an Execute SQL Task icon within the Toolbox. These tasks represent a collection of individual SSIS
programming commands used during ETL processing.
