14. To verify that the package was saved correctly, in Object Explorer
expand the node for your server’s Integration Services instance,
then click Stored Packages | MSDB | Export Product Data. As long
as you see it, it was saved. If it isn’t there, you may have selected
a different name or location in the wizard.
Using Business
Intelligence Development Studio
The ultimate way to create SSIS packages is by using Business Intelligence
Development Studio (BIDS). The Copy Database Wizard and the Import and
Export Wizard both allow you to create and save SSIS packages that perform
specific actions. As your data movement needs become more complex, however,
you’ll likely find that the wizards are too limited in what they can do. Enter BIDS.
BIDS is actually the same Visual Studio 2008 development environment that VB.
Net and C# developers use. When you install BIDS as part of your SQL Server
installation, you get the Visual Studio development environment (if it isn’t already
on your workstation), and a number of “Business Intelligence Projects” project
templates that you can use.
BIDS is a developer tool and is normally run from a developer’s workstation,
not from the server itself. As this book is focused on administrators, not developers,
it isn’t worth digging deep into BIDS. However, we will give a quick overview
because no discussion of SSIS is complete without covering BIDS. As an adminis-
trator, you may want to open a package up in BIDS from time to time to learn
more about what it does or why problems may be occurring.
Let’s look at creating an Integration Services Project in BIDS. To get started,
follow these steps:
Bạn đang xem 14. - THE REAL MTCS SQL SERVER 2008 EXAM 70 432 PREP KIT P77 PPSX