Once you save the connection, you should see it in solution explorer: In this project I selected OLEDB and then followed the “wizard” to find and select the SQL Server instance that I want to target. On the Add SSIS Connection Manager dialog, you can select the type of connection you want to create. To do that, within the Visual Studio Solution Explorer, right click on Connection Managers and select New Connection Manager: For this project, we want to create a connection to a SQL Server.
![visual studio 2017 sql server integration services project visual studio 2017 sql server integration services project](https://sqlstudiesdotcom.files.wordpress.com/2017/07/newssdtproject1.jpg)
SQL Server Integration Services provides different types of connection managers that enable packages to connect to a variety of data sources and servers. Once Visual Studio has created a template project for you, the next step is to create a Microsoft SQL Server Integration Services package connection manager in the project. Next, name the project (I called mine Cycle Sales): To create a SSIS project, open Visual Studio and select Business Intelligence – Integration Services Project. Once you have your environment set, you need to create a “special kind” of visual studio project, that is, a “ Integration Services – Business Intelligence” type project. In addition to these tools, you will also need to make sure that the Integration Services (SSIS) feature is installed as well (SSIS is not installed by default so you may need to run the SQL Server installation again to add it). For this example, I am using Visual Studio 2017, MS SQL Server 2019, and SQL Server Management Studio (version 18.9.1). If you are lucky enough to have an environment preconfigured, wonderful! If not, you’ll need to verify that you have working, and properly configured versions of the tools needed.
#Visual studio 2017 sql server integration services project update
The following outlines the process of creating and deploying a working SSIS package that takes care of loading a staging table from a submitted CSV file as well as using data in an existing fact table to calculate a value and update a gross sales table.
![visual studio 2017 sql server integration services project visual studio 2017 sql server integration services project](https://www.mssqltips.com/tipImages2/6481_install-sql-server-2019-integration-services.006.png)
You can use Integration Services to perform a variety of tasks such as maintaining data hubs that serve Planning Analytics or other enterprise applications. SQL Server Integration Services is a platform for building enterprise-level data integration and data transformations solutions.