SSIS Deploying a package to another Server

• dax.latchford

  SSCommitted

  Points: 1969

  More actions

  August 7, 2018 at 6:13 am

  #368746

  Hi - I have a colleague who has only Visual Studio installed on a Server without SQL. A package has been created & tested successfully. However the requirement is to deploy the package to a SQL2012 Server running Cluster Manager.

  Looking for some advice regarding the steps needed to import this onto the SQL Server and set the package to run automatically on a nightly basis. I've done this before when Visual studio has been installed on the same Server but not in this scenario.

  Any advice would be very much appreciated.

  Kind Regards

  Dax

• tim.ffitch 25252

  SSCrazy

  Points: 2055

  More actions

  September 6, 2018 at 4:33 am

  #2004670

  When you build an SSIS solution in Data Tools or Visual Studio it creates an ispac file in the Bin folder. You can transfer this file to the SQL server to deploy the solution to the SSIS catalog.