SSIS package Deployment using file System

If we are using SSDT then first we need to convert our project to package deployment.

Read here how to convert our package from project deployment to package deployment.

http://bageshkumarbagi-msbi.blogspot.com/2018/12/add-xml-config-file-on-ssdt-2012-and.html

once we convert  this to package deployment in the solution showing Package deployment model.

   

  

We can see this package on the respective folder.

Now we can create a sql server job to run this package.

General table we will do the setting.

    

Go to SETPS tab

     

 

Selecting Type is SQL Server Integration Service Package and Run As SQL Server Agent Account and package source is File System after that we need to select the package location.

If we have configuration file then we need to configure her

     

    

Click ok.

Job is created. Click ok.

    

   

Now we can see it on the  SQL Server Agent Job list.

   

To execute that package we will run this job.

Before running this job records in the database.

  

Running this job.    

Job completed successfully.

See the result in the database.