Deployment Utility
When you have created the package and the package configurations, you are ready to deploy your package to the various computers that are going to do the work. You might not understand the difference between copying a package and deploying a package. Truth is, there’s no difference if your package is simple enough that it has no configuration file or miscellaneous files that have to be taken care of. Deploying a package takes into consideration the package configuration file and any other miscellaneous files when pushing the package to the deployment computer. The following scenarios can be used to deploy a package to a computer:
Using import and export facility of Integration Services within SQL Server Management Studio.
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access