CODEWITHSUNDEEP
sql-serverssis
Anish Patel
Anish Patel

Reputation: 767

How to move an SSIS package from one server moved to another

I was wondering how I would be able to get an SSIS package from a SQL Server that has already been deployed and move it to another SQL Server?

NOTE: I do not have the original package project to just install it on the other server.

Upvotes: 4

Views: 60606

Answers (2)

Christo Pretorius
Christo Pretorius

Reputation: 11

Do the following:

  • Connect to the new server SSIS through SSMS.
  • Open Stored Packages and right click MSDB.
  • Select "Import Package...", set the Server to the source instance (MSDB where the package resides).
  • Click button for "Package path:" and select the package from the list.
  • Set the "Protection level" if applicable or leave the default.
  • Click OK.

You will now have the package transferred to the second server and saved in MSDB. It is not certain that the SSIS package will work without modifications as mentioned by previous post.

Upvotes: 1

grapefruitmoon
grapefruitmoon

Reputation: 3008

It depends on how the package has been deployed. If it's in MSDB, you can right-click the package in SSMS and choose Export Package. You can save it locally as file and the deploy that to another server. If it's on the file system, you can just copy the .dtsx file.

Bear in mind that any hard coded connections may not be able to be changed, unless you can load the package in BIDS.

Upvotes: 7

Related Questions