Chapter 2 Quick Reference

Open table as spreadsheet

This term	Means this
Solution	A container for projects in BIDS. It can contain multiple projects, but at a minimum, a solution contains one project.
Project	Contains all of the files and object definitions for a specific type of business intelligence project (such as Integration Services, Analysis Services, or Reporting Services). All of these files are managed in a file system folder and are referenced in the project definition files.
Business Intelligence Development Studio (BIDS)	A special edition of Visual Studio that is installed with the SQL Server 2005 client tools. No special licensing is required, and it may be distributed freely within the organization for BI and database developers connected to a database server.
SSIS package	Consists of connection managers, control flow tasks, containers, data sources, transformations, and data destinations. These components are used in concert to perform data extract, transform, and load (ETL) operations.
SSIS Import and Export Wizard	Used to create a package from SQL Server Management Studio (SSMS) or from an SSIS project in BIDS. A package and all of its components can also be created manually in an SSIS project within the BIDS environment.
Visual SourceSafe	A version control system similar to Microsoft Team Foundation that is used to manage files and collaborate with other developers. These applications maintain a central copy of the files and allow files to be checked out, checked in, and locked by different developers. A project and all related files should be managed within the developer's personal hard disk or file system. A single project should never be shared between different developers. These files should be backed up regularly regardless of whether they are to be shared with others.
Execute package	In BIDS, a package that can be executed in Debug mode by using the Debug menu or toolbar or from Solution Explorer. In production, the package can be executed from the command line or from a Microsoft Windows utility, or it can be scheduled for automated execution by using the SQL Server Agent.