In
2012, deployment model is based on Project rather than package earlier version.
The new Project Deployment Model in SSIS includes Project/Package Parameters, Environments, Environment variables and Environment references.
STEP 1. Create integration services catalog.
First you need to create an Integration service catalogs to store the data in sql server database.
Now connect to SSMS and go to integration service catalogs in solution explorer.
Right Click on Integration Service catalogs click on Create catalog.
Create catalog window opens, Give name to catalog in the text field provided type SSISDB (default).
User need to specify a password to catalog, click on OK.
“SSISDB” database is created.It’s time to create one folder inside SSISDB database. When we are going to deploy our project than that total content is deployed in this folder only.
To create a folder, Right click on SSISDB and choose create folder option.
STEP 2. Create Integration services project
Once we create a folder named “TEST”, it’s time to go and create a Integration Services project in BIDS to deploy.
STEP 3: Package Deployment
Once you click on “Deploy” option, it will bring up the below window.
Select source page opens, select project deployment and specify path of the project where .ispac file is created. Click Next.
Select Destination page appears, where destination server name and SSIS catalog be given to deploy in the server. Click Next.
Review page appears , where we can review complete deployment process details in summary pane.
Click on deploy button.
Once we click on Deploy option, immediately “Results window” will pop up.
Once our Deployment is over, simply click on Close button.
STEP 4. Checking whether Project deployment is Successful or not?
The below figure shows where the project has been deployed in file system.
The new Project Deployment Model in SSIS includes Project/Package Parameters, Environments, Environment variables and Environment references.
STEP 1. Create integration services catalog.
First you need to create an Integration service catalogs to store the data in sql server database.
Now connect to SSMS and go to integration service catalogs in solution explorer.
Right Click on Integration Service catalogs click on Create catalog.
Create catalog window opens, Give name to catalog in the text field provided type SSISDB (default).
User need to specify a password to catalog, click on OK.
“SSISDB” database is created.It’s time to create one folder inside SSISDB database. When we are going to deploy our project than that total content is deployed in this folder only.
To create a folder, Right click on SSISDB and choose create folder option.
STEP 2. Create Integration services project
Once we create a folder named “TEST”, it’s time to go and create a Integration Services project in BIDS to deploy.
STEP 3: Package Deployment
Once you click on “Deploy” option, it will bring up the below window.
Select source page opens, select project deployment and specify path of the project where .ispac file is created. Click Next.
Select Destination page appears, where destination server name and SSIS catalog be given to deploy in the server. Click Next.
Review page appears , where we can review complete deployment process details in summary pane.
Click on deploy button.
Once we click on Deploy option, immediately “Results window” will pop up.
Once our Deployment is over, simply click on Close button.
STEP 4. Checking whether Project deployment is Successful or not?
The below figure shows where the project has been deployed in file system.
No comments:
Post a Comment
Note: Only a member of this blog may post a comment.