Export (0) Print
Expand All

How to: Create a Package Using SSIS Designer

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

ms141178.note(en-US,SQL.90).gifNote:
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.

  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.

    ms141178.note(en-US,SQL.90).gifNote:
    You can save an empty package.

Community Additions

ADD
Show:
© 2014 Microsoft