SSIS Interview Questions and Answers : Deployment

Deployment

Question: How to create the deployment utility?
Question: How to deploy the packages SSIS?
Question: Where a package does deploys in Integration service database?
Question: What is Manifest file in SSIS?
Question: What is File System Deployment?
Question: how to back up or retrieve the SSIS package?
Question: What are the different databases in Integration services while login through SSMS?

How to Create Deployment Utility:
Deployment is the process in which package converts into development mode to executable mode.
For Deploying the SSIS package you can directly deploy the package by right clicking Integration services
project and build it. This will save the package.dtsx file on bin\project folder. In my case below is the location.
C:\Documents and Settings \My Documents\Visual Studio 2008\projects.
Also you can create the deployment utility using which the package can be deployed at either SQL Server or as a
file on any location.
For creating deployment utility follow below steps.
1. Right Click on project and click on properties, you will get the below screen.
2. In above screen, select true for createDeploymentUtility Option. Also you can set the deployment path.
3. Now close the window after making the changes and build the project by right clicking on project.
4. A deployment folder will be created in BIN folder of your main project location. C:\Documents and
Settings \My Documents\Visual Studio 2008\projects.
5. Deployment folder you will find .manifest file, double clicking on it you can get options to deploy
package on SQL Server.
6. Login in to SQL Server Deploy the package in integration services and you can verify it by checking
MSDB on integration Services.

Question: What is Manifest file in SSIS?

Manifest while if the utility which can be used to deploy the package using wizard on file system and SQL
Server database.

Question: What is File System Deployment?

File system deployment means to save package file on local or network drive.
Question: how to back up or retrieve the SSIS package
If your package is deployed on SQL Server then you can back up the MSDB database as all the package on SQL
server deploys at MSDB.