Creating a new integration services project vs2017

Here's a step-by-step guide to creating a new Integration Services project in Visual Studio 2017:

Prerequisites:

• Visual Studio 2017 (Community, Professional, or Enterprise edition) *.NET Framework 4.6.1 or later
• SQL Server Data Tools (SSDT) installed (comes with Visual Studio 2017)

Step 1: Launch Visual Studio 2017

Open Visual Studio 2017 and click on "File" > "New" > "Project..." to create a new project.

Step 2: Select the Project Type

In the "New Project" dialog box, select "Integration Services" under the "Business Intelligence" section.

Step 3: Choose the Project Template

Select the desired project template:

• "Integration Services Project" (a blank project with no packages)
• "Integration Services Project with Package" (a project with a pre-created package)
• "Integration Services Project with Wizard" (a project with a pre-created package and a wizard to help you create a new package)

For this example, we'll choose "Integration Services Project".

Step 4: Enter Project Details

Enter the project details:

• Project name: Enter a name for your project (e.g., "MyIntegrationProject").
• Solution name: Enter a name for your solution (e.g., "MyIntegrationSolution").
• Location: Choose a location to save your project files.
• Target framework: Choose the.NET Framework version (e.g., ".NET Framework 4.6.1").

Step 5: Create the Project

Click "OK" to create the project. Visual Studio will create a new Integration Services project with a default package (e.g., "Package.dtsx").

Step 6: Explore the Project Structure

In the Solution Explorer, you'll see the following folders and files:

• "Package.dtsx" (the default package)
• "References" (contains references to SSIS assemblies)
• "Solution Items" (contains solution-wide settings and files)
• "Properties" (contains project properties)

Step 7: Start Building Your Integration Services Project

You can now start building your Integration Services project by adding new packages, components, and configurations. You can also use the SSIS Designer to design and build your packages.

That's it! You've successfully created a new Integration Services project in Visual Studio 2017.