Visual Studio 2017 does not have Business Intelligence Integration Services/Projects

sql-server ssis visual-studio-2017 sql-server-data-tools
SKh picture SKh · Apr 28, 2017 · Viewed 129.1k times · Source

I do not see an option to create an SSIS project using Visual Studio 2017.

Answer

kepung picture kepung · Oct 12, 2017

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 :-

enter image description here

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).

enter image description here

Try open your project again. If you get 'incompatible project' - right click on your project, select "reload project" (not reopen the solution)

Related questions

'Microsoft.ACE.OLEDB.16.0' provider is not registered on the local machine. (System.Data)

I get this error when I try to connect to any excel through MSSQL Server Data Import i.e. SSIS package The Microsoft.ACE.OLEDB.16.0 provider is not registered on the local machine. (System.Data) It is not the same …

Read More
Text was truncated or one or more characters had no match in the target code page including the primary key in an unpivot

I'm trying to import a flat file into an oledb target sql server database. here's the field that's giving me trouble: here are the properties of that flat file connection, specifically the field: here's the error message: [Source - 18942979103_txt [424]] …

Read More
How do I fix the multiple-step OLE DB operation errors in SSIS?

I'm attempting to make a DTS package to transfer data between two databases on the same server and I'm getting the following errors. Iv read that the Multiple-step OLE DB operation generated error can occur when you are transferring between …

Read More