Deploying and executing
SSIS packages should be deployed in the production environment. SSIS 2012 introduced a new database as a repository for deployed SSIS projects and packages; this database is called SSIS catalog. SSIS catalog can be accessed through SSMS, which is handy for database administrators. SSIS catalog stores projects, packages, relationships of variables, execution log, and many other types of deployment and execution-related information that is useful in production environments.
Usually, there is no SSDT or development tool in the production environment. So, SSIS packages should be executed using the DTEXEC utility, either through SSIS catalog or from a SQL Server Agent Job. Calling SSIS projects from SQL Server Agent Job is one ...
Get Microsoft SQL Server 2014 Business Intelligence Development: Beginner’s Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
