At work we have an old server and we're moving everything from there to our new server. We're a very small team, and one of my team-members says without visual studio 2015 in the new server he can not transfer/create SSIS packages there. Any thoughts on this?
1 Answer
Visual Studio does not need to be installed on the SQL Server. SSIS packages built with SQL Server Data Tools can be exported to .ispac files, which can then be deployed to servers using SQL Server Management Studio.
See Deploy Integration Services (SSIS) Projects and Packages for more details.
One thing to note is that I've found that deploying .ispac files to SQL Server 2016 servers requires SSMS 2016 for some packages. Packages deployed with later versions of SSMS end up with versioning errors (Source - ODBC is not compatible with this version of the DataFlow).
answered Apr 8, 2020 at 19:40
