Post reply

SSIS Deploying a package to another Server

  • 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

  • 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.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply