How to deploy SSIS Package? Step by Step SSIS.
1- SQL Server:
When a package is deployed to SQL Server, it is actually stored in MSDB database. The easiest way to deploy a SSIS package to SQL Server is by using Package Deployment Utility:
Need to select true value for CreateDeploymentUtility as highlighted below in figure. Once You make this option true press OK or Apply Button.
Right Click on project and click Build
After completing these steps, go to bin -> Deployment folder of your projectís folder and double-click on .SSISDeploymentManifet file. This will launch Package Installation Wizard,which will get you through the necessary steps to deploy your package to SQL Server:
Create New Folder in MS DB (MyPackages)
Select Packages (Mypackages)->Next->Next
Click on Finish
2> Second way
Through File System ->Right Click on mypackages ->Import Package
Choose File System
Select Packages which you want to Load