Deployment of SSIS package
This note intends to address the following issues with regards to deployment of the SSIS packages.
· Migrate the packages from one environment to another-development to integration to production
· Code the job dependency-once a job is completed the second job is to begin.
· Handle multiple database connections across different environments.
· Handle errors while execution of the jobs
Attached is the flow of steps for the deployment of the package.
1. Build the package
2. Convert to deployment model.
3. click on ‘Properties’
Change the deployment utility to ‘true’.
4. Creation of the Manifest file
5. Run the package installation wizard.
6. go to next and check on ‘file system deployment’
7. go to ‘next’ and select that path where you want to deploy your package
8. then go to ‘next’ and ‘finish’ and your deployable package is ready.
Attached are the other blog links:
Blog link: https://mndatasolutionsindia.blogspot.com/
Website: www.mnnbi.com
No comments:
Post a Comment