File System Deployment of the SSIS Package

We can deploy the package using the file system. We will deploy the file on the integration server.

Open the Integration server.

     

Connect this server

                                             

Now click on the stored package

    

Right-click on the File System and create a folder in which we are going to deploy the package.

Here I am creating a folder named My First Package deployment

   

Click Ok.

Now Refresh the File System folder. We will get the newly created package.

   

  Right click on the folder.

         

And select Import package

     

     

Select Package location as file system and select the file path. Click on Open.

    

Click OK. This package is deployed on the Integration server successfully.

See below.

   

Now we can execute the package.

This package is used to move some file from the input folder to the archive folder.

See the archive folder before package execution.

     

Now running this package.

Right click on the package and click on the Run package.

  

Execute package utility window will be open.

       

         

Click on the Execute button.

The package will start executing

   

It completed successfully.

Now see the Archive folder.