Export (0) Print
Expand All

How to: Create or Delete a Package in Business Intelligence Development Studio

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.

The following procedures describe how to create or delete a package in Business Intelligence Development Studio.

To create a package in Business Intelligence Development Studio

  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.

    NoteNote

    You can save an empty package.

To delete a package in Business Intelligence Development Studio

  1. In Business Intelligence Development Studio, open the Integration Services project that contains the package you want to delete.

  2. In Solution Explorer, right-click the package, and then click Delete.

  3. Click OK to confirm the deletion or click Cancel to keep the package.

Community Additions

ADD
Show:
© 2014 Microsoft