CREATING A NEW INTEGRATION SERVICES PROJECT.

An Integration Services Project is a type of project in Microsoft SQL Server Integration Services (SSIS) that enables the integration of data from various sources into a unified platform. It is commonly used for Data migration and consolidation, Data warehousing and business intelligence, Data integration for analytics and reporting

Follow these simple steps to create a new integration services project in visual studio.

1. Go to the start menu bar, search for and select  visual studio and launch it
2. In the software visual (studio code) click on file, click on create a new project to create a new integration service project.

3. In the dialogue box, navigate down and click on integration services project, click on next.

4. In the name box that appears with the project name written “integration services project”, change the name to SSIS Tutorial.

5. Click on the box for place solution and project in same directory to save in same directory.

6. Click on create

7. A visual studio window will come up

8. If yours is  not looking dark, no problem, it’s a background setting. To do that, you can go to tools, click on theme and u can change it to any theme of your choice.

9. On the right hand side box, right click on package.dts and rename it to lesson_1.dts. While renaming, “DO NOT USE SPACE”. Make sure to hit backspace to erase all spaces.

10. It’ll ask you to load everything into the new name, click on yes to all.