Deploy SSIS Package via .SSISDeploymentManifest file

1. Copy SSIS package to server.
2. Run xxxxxx.SSISDeploymentManifest file

Deployment with this method will set the database connection string.

SSIS Package deployment using SSIS deployment manifest file seems to be the most reliable and trouble free way.