How to deploy SSIS package to sql server

When we are ready to deploy our packages we have the following options available:

• Deploy to the file system
• Deploy to the package store
• Deploy to SQL Server

The simplest approach to deployment is probably to deploy to the file system.  As SSIS package is actually just an XML file and it can simply be copied from its project location to a folder on the deployment target. SSIS packages deployed to SQL Server are stored in the msdb database.

Follow below steps to deploy SSIS package in SQL Server

Step 1:  Navigate to Package path then double click the Integration Services Deployment Manifest file.

Step 2:   Below window will be displayed, now click next

Step 3:    

There are two types of deployment

·         File system deployment and

·         Sql Server deployment

Select Sql Server Deployment and click next

Step 4: Now specify target machine server name with credentials and click browse and select the path. Click next. 

Step 5:Now select the path in which the dependencies of package will install and then click next

Step 6: Click Next

Step 7: This windows shows configuration file details, click next

Step 8 In this window check the summary and click finish. Now you are done with your deployment. You can check by log in target server’s SQL server Management studio. Connect to integration services and under stored packages. You can find your deployed package.