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 SQL Server Integration Services. To do so, First Double click on Data Tools or Business Intelligence Development Studio (shortly called BIDS)
First, select the File option from the Menu item. Next, select New and then select the New Project… option to create a new Project.
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.
Click Ok to finish creating a new SQL Server Integration Services project.
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 to create a package level connection managers
- Package: Design package