SSIS:Deploying Package

Refer the source Video:Deploying Package

SQL Server 2008 :Deploy package in 2 ways File system,MSDB.
Right click->Package Configuration->(check) Enable package configuration ->
Configuration type:XML configuration file 
( )Specify configuration settings directly
   Configuration file name: create a file 

( ) Configuration location stored in environment variable

Specify what values we want to read from the configuration file.Map the "Server Name" Value & then "Table Name" Value.

For creating Deployment Utility:Choose Solution->Right click->Properties->"Deployment Utility"  CreateDeploymentUtility:True

When from Menu->Build , it creates in the Path , mentioned in "Full Path"
..\bin\Deployment folder all files are their. .dtsx files, .SSISDeploymentManfest, .dtxConfig 

File system:
-----------------
i.Double click on .SSISDeploymentManfest , it will start the package installation wizard.(check)-File System Deployment  - SQL Server deployment 
   ( stores in MSDB database , burden on Sql Server)
just shows the   .dtxConfig file parameters.
ii.Create a job: SQL Server Agent - job - New Job  type:SQL Server Integration Services Package
Package Source: Choose "File System"

After Finishing steps , right click on job ->Start the job.
-------
MSDB:
---------
i.Double click on .SSISDeploymentManfest , it will start the package installation wizard.
(check)-File System Deployment  - SQL Server deployment 
   ( stores in MSDB database , burden on Sql Server)
just shows the   .dtxConfig file parameters.
ii.Create a job: SQL Server Agent - job - New Job  type:SQL Server Integration Services Package
Package Source: Choose "SQL Server"

Check on MSDB database that the job is created.After Finishing steps , right click on job ->Start the job.


-------