Deploying a Package:
The deploying Package requires Two steps only.
- Creating a package installer by using the Package Deployment Utility
- Deploying the Installer set to you new Deployment Destination.
When you move your package from the development environment to your test or production machines, you have two options for package storage.
- SSIS Deployment to the File System
- SSIS Deployment to SQL Server.
SSIS Deployment to the File System:
In this package can placed on File shares or in File Folder from which they can be executed.
SSIS Deployment to SQL Server:
Package can be imported into SQL server, from which they can be executed. When the packages are stored in SQL Server, SSMS connect to SSIS to manage them.
When you deploy SSIS package to SQL Server, the package stored in the MSDB database in the table name called DBO. SYSSSISPACKAGES.
Deployment can be manually or can be driven through the Deployment utility.
Deployment Utility:
SSIS Built in Automated tool. The Package deployment utility can also deploy packages either to the File System or to a SQL Server. The main use of this Deployment Utility is can deploy entire package at the same time to File System or SQL SERVER.
When you enable the Deployment Property, i.e "Create Deployment Utility to True" the following items in the project are copied to single folder location.
- Packages
- Miscellaneous Files
- Project Deployment manifest
No comments :
Post a Comment