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:

• Open your SSIS project in BIDS (Business Intelligence Development Studio),
• Right-click on the project entry in solution explorer and select properties,
• Navigate to deployment tab, and set CrteateDeploymentUtility to true,
• Build your project.

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)

• In the Deploy SSIS Package page of the wizard, select SQL Server deployment and click Next:

Select Packages (Mypackages)->Next->Next

Click on Finish

Refresh MyPackages

2> Second way

Through File System ->Right Click on mypackages ->Import Package

Choose File System

Select Packages which you want to Load