Where Is Everything?


Integration Services isn't just one application, but a collection of components, utilities, engines, and wizards. You'll want to know where these are, so the following sections provide a list of the most useful files and where to find them.

Business Intelligence Development Studio

The Business Intelligence Development Studio is the designer and development environment for all Business Intelligence applications. You can find a link to it in the Microsoft SQL Server 2005 menu tree on the Start menu.

Management Studio

Management Studio is the management interface for accessing the SQL Server services, including SQL Server, Analysis Services Server, Reporting Services Server, and Integration Services Server. It is in the same location as the Business Intelligence Development Studio. Figure 2.9 shows the SQL Server 2005 menu.

Figure 2.9. Most SQL Server applications can be started from the Start menu


Import/Export Wizard

Not all SQL Server applications can be started from the Start menu. The Import/Export Wizard is what you use to quickly generate Integration Services packages for moving data from one location to another. It is not on the Start menu. To make it easier to find, put it on the Start menu or, a favorite, the Quick Launch toolbar on the taskbar. To find it, open Windows Explorer and go to the location where you installed SQL Server. It should be in Program Files under the Microsoft SQL Server\90\DTS\Binn folder. The filename is DTSWizard.exe. Right-click on this file in Windows Explorer and drag it to the taskbar. When the shortcut menu appears, click Create Shortcut Here.

Migration Wizard

The Migration Wizard is what you use to migrate DTS packages to IS packages. It's not on the Start menu either. You can find it in the same location as the Import/Export Wizard and the name is DTSMigrationWizard.exe. You can place it on the Quick Launch toolbar right next to the Import/Export Wizard.

DTExec, DTUtil

These two command-line utilities are for executing (DTExec) and managing, moving, and deleting (DTUtil) packages. They are also in the same folder as the Import/Export Wizard. Setup automatically creates a path entry to this folder so these utilities will always be available on the command line.

DTExecUI

DTExecUI is the package execution utility with a graphical user interface (GUI). You can use it to build command lines for DTExec, execute packages directly, and pass parameters to the package. If you double-click a package file in Windows Explorer, DTExecUI appears. Setup puts DTExecUI.exe in the Program Files folder under Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE.



Microsoft SQL Server 2005 Integration Services
Microsoft SQL Server 2005 Integration Services
ISBN: 0672327813
EAN: 2147483647
Year: 2006
Pages: 200
Authors: Kirk Haselden

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net