How to: Create a Package Using SSIS Designer

  • Article

This topic describes how to create a SQL Server 2005 Integration Services (SSIS) package by using the graphical design interface.

Note

When you first add a project to a solution, SSIS automatically adds an empty package to the project. You can rename that package at any time.

The packages that you create in Business Intelligence Development Studio using SSIS Designer are saved to the file system. To save a package to SQL Server or to the package store, you need to save a copy of the package. For more information, see How to: Save a Copy of a Package.

To create a package

  1. In Business Intelligence Development Studio, open the Integration Services project in which you want to create a package.

  2. In Solution Explorer, right-click the SSIS Packages folder, and then click New SSIS Package.

  3. Optionally, add control flow, data flow tasks, and event handlers to the package. For more information, see Creating Package Control Flow, Creating Package Data Flow, and Creating Package Event Handlers.

  4. On the File menu, click Save Selected Items to save the new package.

    Note

    You can save an empty package.

See Also

Concepts

Package How-to Topics (SSIS)

Other Resources

Designing and Creating Integration Services Packages

Help and Information

Getting SQL Server 2005 Assistance