I have two versions of Visual Studio installed: VS 2015 and VS 2017 on two different machines.
As such, my question is two fold as each has an issue.
VS 2015: I am able to create SSIS packages in VS 2015 and I am trying to build a package that works with Excel files. For some reason, I can only work with *.xls files, but not *.xlsx files as the component for this is not installed. What do I need to install to be able to work with *.xlsx files in VS 2015?
VS 2017: I do not have the Business Intelligence option for Integration Services. What needs to be installed for VS 2017 to allow me to create SSIS packages that can import *.xlsx files?
Any help is appreciated