Solutions and Projects
SQL Server 2005 offers different environments for developing and managing Integration Services packages. These packages are designed and created in BIDS, while developed and deployed packages are managed for storage and execution in SQL Server Management Studio. Both environments have special features and toolsets to help you perform the jobs efficiently.
You cannot use SQL Server Management Studio to edit or design Integration Services solutions or projects. However, in both environments, you use solutions and projects to organize and manage your files and code in a logical, hierarchical manner. A solution is a container that allows you to bring together scattered projects so that you can organize and manage them as one ...
Get Hands-On Microsoft SQL Server™ 2005 Integration Services now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
