SSIS: How do you deploy SSIS packages?

Answer:


SQL Server 2005 Integration Services (SSIS) makes it simple to deploy packages to any computer.


There are two steps in the package deployment process:


-The first step is to build the Integration Services project to create a package deployment utility.


-The second step is to copy the deployment folder that was created when you built the Integration Services project to the target computer, and then run the Package Installation Wizard to install the packages.

SSIS Interview Questions And Answers