 Hello, welcome to SSUnitech, so say this side and this is continuation of SSIS tutorial. So today we are going to discuss about how we can deploy any package. So go to SSDT and here as we can see we have a project with the name of package deployment. So we want to deploy all the packages which is available inside this directory. So here we have two packages, first is flat file to database and second is database to flat file. So in our first package, let me concentrate on this. And here we have flat file source and OLEDB destination. So we want to load data from flat file to OLEDB destination. So before going to deploy the package, go to on SSMS and do couple of things. So go to on SSMS and here as we can see we have integration service catalogs. So initially we don't have anything. So we need to create integration service catalog. So right click on this and then create a new catalog. So once we will create a catalog, so all the packages which we will deploy will be stored inside this catalog. So here we need to enable our CLR then enable automatic execution of integration service stop procedure at SQL server setup. So here as we can see we have SSISDB which is our catalog name and once we will click on OK then it will automatically create a database with the name of SSISDB. So here we can specify a password. So I am going to specify a password and then we can click on OK. So as we can see we are having SSISDB which is our catalog. So go to on databases and inside this database let me refresh this then we can see we are having SSISDB and inside this SSISDB we have couple of tables and we don't need to touch those tables. So here we can create any folder and inside that folder we can specify our packages which will be deployed. So here I am going to specify folder name with the demo then click on OK. As we can see folder is created and inside this folder we are having projects and inside this project at yet we don't have anything. Once our package will be deployed then those packages will be placed inside this project and then environment we don't have anything. We will discuss about environments in our next video. So go to on SSDB to deploy the package simply right click on this package deployment then deploy our package. Now we can click on next here we need to specify our destination server name so we can browse. So this is our destination server name so click on OK go to on path. So as we can see we are having demo folder so I want to deploy the package inside this demo folder. Now click on OK then go to on next simply click on deploy it is going to loading project then connecting to destination server then changing protection level and then deploying the package. So we have done now click on close. So we have done now go to one file so this is our file we can open. So here we are having five records go to on SSMS in this table we are having only 30 records. So once our package will be executed then five records should be inserted in this table. So let me refresh this demo folder go to on projects we are having this package deployment now we can expand go to on packages. So here we are having all the packages which is available on the SSDB. So I need to concentrate on flat file to database now simply right click on this and we can execute directly over here. Now we can click on execute so it will open execute package window now we can simply click on OK. So would you like to open overview report so I can click on yes I want to see the report so as we can see our package executor successfully and here we are having certain informations like operator ID package then environment status which is our succeed it means package executed successfully then the machine name then here we can see this is our task name and this is data flow task so here we are having all the informations now we can close this report so go to on the table. So here as we can see we are having 35 records previously it was 30 records so in this video we have discussed how we can deploy the package and how we can run the package manually from SQL Server Management Studio and also we have discussed how we can create integration services catalog in our next video we will discuss how we can use the environment and how we can deploy the package if any variables are available on the package. So thank you so much for watching this video if you like this video please subscribe our channel to get many more videos don't forget to press the bell icon to get the notification of our newly uploaded videos thank you so much.