SSIS Package Deployment

• Creating a SSIS Package
• Using Packing configuration:
• SSIS->Package Configuration->select connection string for db connection
• Build package
• In the deployment folder, modify *.dtsconfig with password like the following

Data Source=colvts02;uid=configurator;pwd=configurator;Initial Catalog=ST_Support;

• Copy deployment folder to target server
• Double click *.deployment file , during installation , specified a installation folder with writing permission (without enough permission, might get error that the config file access is denied)