SSIS Project Deployment | SSIS Package Deployment | ssis tutorial part 68 – Transcript

00:00Hello, welcome to SSUnitech, so say this side and this is continuation of SSIS tutorial. So today we gonna 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.

00:17So we want to deploy all the packages which is available inside this directory. So here we have two packages, first is flatfile to database and second is database to flatfile. So in our first package let me concentrate on this.

00:33And here we have flatfile source and OLEDB destination. So we want to load data from flatfile 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.

00:53So 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.

01:11So here we need to enable our CLR then enable automatic execution of integration service store 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.

01:34So 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.

01:52Go 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.

02:08So 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.

02:23As you 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.

02:41We 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.

03:06So 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.

03:24It 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.

03:41So 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.

04:06So here we are having all the packages which is available on the SSDB. So I need to concentrate on that 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.

04:26So would you like to open or 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

04:55task 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.

05:13So 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.

05:33So 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.