Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

Step 1: Creating a New Integration Services Project

 

Applies To: SQL Server 2016 Preview

The first step in creating a package in Integration Services is to create an Integration Services project. This project includes the templates for the objects — data sources, data source views, and packages — that you use in a data transformation solution.

The packages that you will create in this Integration Services tutorial interpret the values of locale-sensitive data. If your computer is not configured to use the regional option English (United States), you need to set additional properties in the package. The packages that you use in lessons 2 through 5 are copied from the package created in lesson 1, and you need not update locale-sensitive properties in the copied packages.

System_CAPS_noteNote

This tutorial requires Microsoft SQL Server Data Tools.

For more information on installing the SQL Server Data Tools see SQL Server Data Tools Download.

To create a new Integration Services project

  1. On the Start menu, point to All Programs, point to Microsoft SQL Server, and click SQL Server Data Tools.

  2. On the File menu, point to New, and click Project to create a new Integration Services project.

  3. In the New Project dialog box, expand the Business Intelligence node under Installed Templates, and select Integration Services Project in the Templates pane.

  4. In the Name box, change the default name to SSIS Tutorial. Optionally, clear the Create directory for solution check box.

  5. Accept the default location, or click Browse to browse to locate the folder you want to use. In the Project Location dialog box, click the folder and click Select Folder.

  6. Click OK.

    By default, an empty package, titled Package.dtsx, will be created and added to your project under SSIS Packages.

  7. In Solution Explorer toolbar, right-click Package.dtsx, click Rename, and rename the default package to Lesson 1.dtsx.

Community Additions

ADD
Show:
© 2015 Microsoft