Create a SSIS Project

SSIS Projects are used to extract data from a wide variety of sources, transform data, and finally load data into the destination. In this article, we will show the step by step approach to creating an SSIS project with an example.

How to Create an SSIS Project?

In this example, we will show the steps involved in creating a New Project in SSIS SQL Server Integration Services. To do so, First Double click on Data Tools or Business Intelligence Development Studio (shortly called BIDS)

Open Visual Studio 1

First, select the File option from the Menu item. Next, select New and then select the New Project… option to create a new Project.

Create a SSIS Project 2

Once we click on the New Project… option, a new window called New Project will open. Use this window to select the required project from available project templates.

Let’s select the Integration Services Project under the Business Intelligence Templates. Next, we changed the project name to SQL Integration Services Project.

Add Name, Solution, and Location to Create a SSIS Project 3

Click Ok to finish creating a new SQL Server Integration Services project.

Create a SSIS Project 4

Let’s explain individual windows after creating an SSIS project

  • Solution Explorer: Use this window to create project-level connection managers and packages.
  • Properties: Helps to change the properties of each task.
  • Toolbox: Drag and Drop the tasks, containers, transformations, sources, and destinations to design the package.
  • Information: Click on the toolbox items to see the information in this window.
  • Connection Managers: Use this one to create package level connection managers.
  • Package: Design package.

About Suresh

Suresh is the founder of TutorialGateway and a freelance software developer. He specialized in Designing and Developing Windows and Web applications. The experience he gained in Programming and BI integration, and reporting tools translates into this blog. You can find him on Facebook or Twitter.