pcalabria
asked on
Need to know how to Install Integration Services (SSIS) on SQL Server 2017
I have already installed and use SQL Server 2017, but apparently did not install the Integration Services.
Can anyone provide me with help? I don't want to reinstall SQL Server.. Thanks
Can anyone provide me with help? I don't want to reinstall SQL Server.. Thanks
Execute the SQL Server 2017 Installation Center and click on the first option in Installation menu. It will allow to add missing features to the existing installation.
ASKER
Thats the problem.. it brings me to this screen:
Download SQL Server Data Tools (SSDT) - SQL Server Data Tools (SSDT) | Microsoft Docs
and I'm not sure what to click. I don't understand the reference to Visual Studio...??
Download SQL Server Data Tools (SSDT) - SQL Server Data Tools (SSDT) | Microsoft Docs
and I'm not sure what to click. I don't understand the reference to Visual Studio...??
Data Tools allow you to create SSIS applications (and not only SSIS application) in Visual Studio 2017.
ASKER
When I click the link on that you are showing a box pops up asking to browse for the SQL Instalation Media..
Sounds like the install program is not on my disk??
Very confused.
Sounds like the install program is not on my disk??
Very confused.
I don't know where is your installation media... You can use the installation DVD, mapped installation image but it can also be on your disk from the previous installation.
ASKER
I"m sure I downloaded it from Microsoft... its free to download.. not sure what happened to the install program?? That's why I posted.. not sure what to do..
If I download and install again I may mess things up????
If I download and install again I may mess things up????
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks