Creating a BI Project for SSIS in Visual Studio 2005
[ 70 ]
This opens the SQL Server 2005 Management Studio below.
Choose Integration Services from the drop-down. It will be showing the
configured authentication information. In this case it is authenticated
by Windows.
2. Now click on the Connect button. This will open the Integration Service
Server below (showing all nodes expanded out).
Chapter 2
[ 71 ]
3. Now right-click either on the File System folder or on the MSDB folder
and choose the Import Package sub-menu item, which opens the following
window. From the drop-down, choose File System. For Windows
authentication, you do not need User name and Password when you choose
File System, Package Path.
4. Now click on the Package Path button and browse to the location where it is
saved (where the package.dtsx is saved). This adds the package name (in
the case of project Ch 2 the package name is Package).
5. Now click on the button OK.
Creating a BI Project for SSIS in Visual Studio 2005
[ 72 ]
This adds the package to the MSDB folder.
Hands-On Exercise 3
In this exercise, you will be invoking the export/import wizard from the MS SQL
Server 2005 Management Studio.
1. Start up the SQL Server 2005 Management Studio.
2. Right-click on Management.
Chapter 2
[ 73 ]
3. Now click on either Import Data??¦ or Export Data??¦ to open the wizard.
Summary
This chapter described the creation of an SSIS project containing a default package,
adding and removing objects from the toolbox, and getting acquainted with the
various menus, windows, and other project items.
Pages:
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67