On our current installation of SQL Server 2008 R2, we have created several SSIS jobs. SQL Server Business Intelligence Development Studio is installed on our database server and that is what we used to create the SSIS jobs.
We are now in the process of migrating to a new database server that is running Windows Server 2016 and SQL Server 2016. I understand that SQL Server Business Intelligence Development Studio has been replaced by SQL Server Data Tools, which we will now need to manage our existing SSIS jobs as well as create new ones.
Can SQL Server Data Tools be installed on our new server, along with Visual Studio, or do they have to be installed on my workstation?
Answer by JohnM · Jul 19, 2018 at 12:15 PM
You have to install SQL Server Integration Services on the instance and you can install the tools on the server as well. However, it's usually bad form to develop things locally on the server. Having the tools on the server just increase 1) support and 2) the security footprint. Less is usually better for servers. It's better to install the tools locally on the workstation(s) and do your development/support from there.
SSIS Package Status 2 Answers
partition & parallel ETL load 3 Answers
Best way to extract CLOB datatype from oracle to SQL db using SSIS 2005 1 Answer
using wmi event task in ssis for loading files into database tables 2 Answers
SSIS 2005 - How to figure out what job a sysdtslog90 entry was run under? 0 Answers