Menu
I do not see an option to create an SSIS project using Visual Studio 2017.
331
Visual Studio 2017 To install it, go to Tools… Extensions and Updates… go to the Online tab and then search for BI Developer Extensions: You can also download it from the Visual Studio Marketplace in a web browser here. Ensure you have the latest version of SSDT installed for Visual Studio 2017.
In Visual Studio, click New > Project on the File menu. In the Installed Templates area of the New Project window, expand Business Intelligence, and click Integration Services. Select Integration Services Import Project Wizard from the project types list.
To confirm SSDT is installed, click on Help / About Microsoft Visual Studio and look for SQL Server Data Tools in the list. The latest version of SSDT is 14.0. 60525.0. If the option to install is not available from Visual Studio, alternatively you can visit the SSDT Download page to download and install SSDT manually.
VS2017 supports ssis or ssrs projects if you install SSDT for VS2017 here.
Click on the newly downloaded file and check SSIS or SSRS components that you required, as show in diagram :-
Once you have installed this, try opening ssis / ssrs project. I managed to open ssis developed on vs2010.
You should see these component installed. (reboot if you don't see them).
Try open your project again. If you get 'incompatible project' - right click on your project, select "reload project" (not reopen the solution)
186
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
