The SSIS Packages folder has its own drop-down as shown in the next screenshot.
Here you see even more SSIS functionality. You can bring up an export/import
wizard which will guide you through the data transfer process. You may even
choose to migrate a stored package designed using the DTS and stored in SQL Server
2000. Of course, leaving aside the default package you can start a new package.
SSIS Import and Export Wizard??¦ can also be invoked from inside SQL Server 2005
management studio by right-clicking on the management node and choosing Export
or Import menu items (see Hands-On Exercise 3 Invoking Export, Import Wizard in
SQL Management Studio).
Chapter 2
[ 53 ]
Getting Various Windows
Besides the various windows we have seen so far, there are many windows available
for various kinds of tasks. All these can be accessed by clicking on the main menu
item, View. This brings up a drop-down menu, as shown below:
The various windows provide information regarding objects, processes, errors,
properties, etc.
Creating a BI Project for SSIS in Visual Studio 2005
[ 54 ]
Server Explorer Window
Server Explorer shows you the data sources to which you are connected. You
can establish a connection by right clicking on the connection and choosing Add
Connection??¦which brings up the window shown next. Right now it is showing one
active connection and one inactive connection. You could connect to several sources
using this window.
Pages:
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59