Data Integration Life Cycle Management with SSIS : A Short Introduction by Example

Build a custom BimlExpress framework that generates dozens of SQL Server Integration Services (SSIS) packages in minutes. Use this framework to execute related SSIS packages in a single command. You will learn to configure SSIS catalog projects, manage catalog deployments, and monitor SSIS catalog execution and history.__Data Integration Life Cycle Management with SSIS__ shows you how to bring DevOps benefits to SSIS integration projects. Practices in this book enable faster time to market, higher quality of code, and repeatable automation. Code will be created that is easier to support and maintain. The book teaches you how to more effectively manage SSIS in the enterprise environment by drawing on the art and science of modern DevOps practices. **What You'll Learn** * Generate dozens of SSIS packages in minutes to speed your integration projects * Reduce the execution of related groups of SSIS packages to a single command * Successfully handle SSIS catalog deployments and their projects * Monitor the execution and history of SSIS catalog projects * Manage your enterprise data integration life cycle through automated tools and utilities **Who This Book Is For**Database professionals working with SQL Server Integration Services in enterprise environments. The book is especially useful to those readers following, or wishing to follow, DevOps practices in their use of SSIS. Build a custom BimlExpress framework that generates dozens of SQL Server Integration Services (SSIS) packages in minutes. Use this framework to execute related SSIS packages in a single command. You will learn to configure SSIS catalog projects, manage catalog deployments, and monitor SSIS catalog execution and history. Data Integration Life Cycle Management with SSIS shows you how to bring DevOps benefits to SSIS integration projects. Practices in this book enable faster time to market, higher quality of code, and repeatable automation. Code will be created that is easier to support and maintain. The book teaches you how to more effectively manage SSIS in the enterprise environment by drawing on the art and science of modern DevOps practices. What You'll Learn Generate dozens of SSIS packages in minutes to speed your integration projects Reduce the execution of related groups of SSIS packages to a single command Successfully handle SSIS catalog deployments and their projects Monitor the execution and history of SSIS catalog projects Manage your enterprise data integration life cycle through automated tools and utilities Who This Book Is For Database professionals working with SQL Server Integration Services in enterprise environments. The book is especially useful to those readers following, or wishing to follow, DevOps practices in their use of SSIS. Annotation. Build a custom BimlExpress framework that generates dozens of SQL Server Integration Services (SSIS) packages in minutes. Use this framework to execute related SSIS packages in a single command. You will learn to configure SSIS catalog projects, manage catalog deployments, and monitor SSIS catalog execution and history. Data Integration Life Cycle Management with SSIS shows you how to bring DevOps benefits to SSIS integration projects. Practices in this book enable faster time to market, higher quality of code, and repeatable automation. Code will be created that is easier to support and maintain. The book teaches you how to more effectively manage SSIS in the enterprise environment by drawing on the art and science of modern DevOps practices. What You'll LearnGenerate dozens of SSIS packages in minutes to speed your integration projectsReduce the execution of related groups of SSIS packages to a single commandSuccessfully handle SSIS catalog deployments and their projectsMonitor the execution and history of SSIS catalog projectsManage your enterprise data integration life cycle through automated tools and utilitiesWho This Book Is ForDatabase professionals working with SQL Server Integration Services in enterprise environments. The book is especially useful to those readers following, or wishing to follow, DevOps practices in their use of SSIS Front Matter ....Pages i-xiii Introduction to DIML (Andy Leonard)....Pages 1-5 SSIS (Andy Leonard)....Pages 7-24 Source Control (Andy Leonard)....Pages 25-39 Deploy to the SSIS Catalog (Andy Leonard)....Pages 41-59 Configure the SSIS Catalog Project (Andy Leonard)....Pages 61-82 Catalog Browser (Andy Leonard)....Pages 83-94 SSIS Catalog Compare (Andy Leonard)....Pages 95-122 SSIS Framework Community Edition (Andy Leonard)....Pages 123-129 Catalog Reports (Andy Leonard)....Pages 131-135 BimlExpress Metadata Framework (Andy Leonard)....Pages 137-175 Conclusion (Andy Leonard)....Pages 177-177 Links (Andy Leonard)....Pages 179-180 Back Matter ....Pages 181-185