I'm trying to use SSIS of SQL Server 2014, I already had SQL Server so I've followed some tutorials of how to add the SSIS functionality. I downloaded the setup of SQL Server but SSIS is missing when I look for it.
I read on a previous post that it's because I'm downloading SQL Server express https://www.microsoft.com/en-us/download/details.aspx?id=42299 and that version doesn't have that feature.
But I've seen videos where they have the same link and to them do appear the SSIS when they're doing the same procedure.
My question: what can I do to use SSIS of SQL Server because I have Windows 7 and other versions as SQL Server 2016, 2017 need Windows 8 or newer, but I don't want to install them.
You can download SQL Server Developer Edition, if you are just planning to use it for development purposes. It is having SSIS coming with it.
SQL Server Developer Edition 2014 supports Windows 7. You can see more details here
The SQL Server Developer Edition 2014 download instructions are available in the Stackoverflow post
You need to install Sql Server Developer Tools-BI (SSDT-BI) to work on Integration Services Project. You can download SSDT from here. Choose the one corresponding to SQL Server 2014.