SSIS Deployment Tip

 

(1) Can create package via import/export wizard and save as ssis package.

(2) . Create a ssis project in BIDS and add the package created from last step.

(3) Check connection manager and execute task to make sure it is working properly.

(4) . Project—> [Project] Properties –> set create deployment true

(5) SSIS—> Package Configuration—>Enable package configuration and add a new xml config file

(6) Modifying config file for deployment ( this is very important )

(7) Deployment: click *. *deploymentmanifest in deployment folder to deploy

Helpful link :

 

http://www.cnblogs.com/invinboy/archive/2010/02/02/1661459.html