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
