SSIS Deployment Final

1. After Creating SSIS package , create package configuration from VS->SSIS->Package Configuration->ADD/EDit a config file -> Select property of connection string used in project
2. Build package
3. Copy deployment folder to target server
4. Modify config.dtsconfig file , replace with "uid=configurattor; pwd=rich2009" to connection string section
5. Save config.dtsconfig
6. right click deployment file to deploy. select sql storage , select a different file folder for final location,....
7. Test : goto intergration service of server->stored packages->MSDB->right click package to run (no need to specify config)
8. Can create a job to execute this package periodally