| title | description | author | ms.author | ms.reviewer | ms.date | ms.service | ms.subservice | ms.topic |
|---|---|---|---|---|---|---|---|---|
Step 1: Create a new Integration Services project |
Lesson 1-1: Create a new Integration Services project |
chugugrace |
chugu |
mikeray |
09/17/2024 |
sql |
integration-services |
tutorial |
[!INCLUDE sqlserver-ssis]
The first step in creating a package in [!INCLUDE ssISnoversion] is to create an [!INCLUDE ssISnoversion] project. This example project includes templates for the data sources, data source views, and packages that make up a data transformation solution.
The packages that you create in this [!INCLUDE ssISnoversion] tutorial interpret the values of locale-sensitive data. If your computer isn't 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 6 are copied from the package you create in this lesson.
Note
If you haven't already, see the Lesson 1 prerequisites.
-
On the Windows Start menu, search for and select Visual Studio (SSDT).
-
In Visual Studio, select File > New > Project to create a new [!INCLUDE ssISnoversion] project.
-
In the New Project dialog box, expand the Business Intelligence node under Installed, and select Integration Services Project in the Templates pane.
-
In the Name box, change the default name to SSIS Tutorial. To use a folder that already exists, clear the Create directory for solution check box.
-
Accept the default location, or select Browse to browse to locate the folder you want to use. In the Project Location dialog box, select the folder and then Select Folder.
-
Select OK.
By default, an empty package titled Package.dtsx is created and added to your project under SSIS Packages.
-
In Solution Explorer, right-click Package.dtsx, select Rename, and rename the default package to Lesson 1.dtsx.