Sunday, 9 December 2018

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.

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.
  

1 comment:

  1. Nice and good article. It is very useful for me to learn and understand easily. Thanks for sharing
    Msbi Online Training India
    Msbi Certifiacation Training

    ReplyDelete

If you have any doubt, please let me know.

Popular Posts