Scenario: development environment and production environment
You created SQL server SSIS package to import data in your development environment. After successfully testing the SSIS package, you want to deploy the SSIS package in your production environment. However, your production environment uses a different table names than your development environment. What do you do?
Creata a SQL Server package configuration
Build a deployment utility (right click on the Project--properties--Deployment Utility--AllowConfigurationChanges to True--CreateDeploymentUtility to True--Build the project);
Copy the deployment folder of your SSIS project to your production SQL Server;
Execute the manifest file;
Note:
The deployment utility is a folder that contains the files you need to deploy the packages in an Integration Services project on a different server.
AllowConfigurationChange --A value that specifies whether configurations can be updated during deployment, such as the table name change.
