The starting point in creating a package is to create a
Business Intelligence Project using the Integration Services Project - a
standard Visual Studio 2005 installed template as shown in Figure 3. It has
been given a name here, Editor Basics.
Figure 3
This creates the EditorBasics
project in the Solution Explorer as shown below. It comes with the folders,
Data Sources, Data Source Views and SSIS packages. You could further expand
this node to see its contents. By right clicking this node, you reveal the
drop-down menu from which you can do a number of things. Click on the New SSIS Package menu item.
Figure 4
You could also create a new package as shown in Figure 5. This
figure shows other details for the Package1.dtsx [Design] tab as well.
Figure 5
The Package consists of the following: Control Flow, Data
Flow, Event Handlers, and Package Explorer. More items may show up during
package development. Please read the grayed text Control Flow of the package, this
explains how to configure this part. The pane in the bottom is where the
connections are placed called the Connection Managers.
Figure 6
The Data Flow page shows the data
flow tasks that are needed by the package. You can click on the link to add
the Data Flow task(s) as shown below.
Figure 7
In the Event Handlers page, for
each task configured you could attach an Event Handler (default OnError).
Figure 8
The Package Explorer is an explorer style list of all items in
the package.
Figure 9
