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

Intro -- Table of Contents -- About the Author -- Acknowledgments -- Foreword -- Chapter 1: Introduction to DILM -- Some History -- SSIS Is a Software Development Platform -- SSIS Is an Enterprise Data Integration Engine -- SSIS Is Difficult to Learn -- Lifecycle Management -- Solutions and Credit Where Credit Is Due -- Chapter 2: SSIS -- The Demo -- Adding Package Parameters -- Adding Project Parameters -- A Note About Variables, Parameters, and Scope -- Adding an Execute SQL Task -- A Note About SSIS Variable Scope -- Adding a Script Task -- Why C#? -- Why ProjectName and TaskName? -- Testing .Net Code Compiles Before Closing the VSTA Editor -- Testing Progress -- Conclusion -- Chapter 3: Source Control -- Source Control Client -- Creating a Team Project -- Configuring SSDT to Use TFS Online -- Chapter 4: Deploy to the SSIS Catalog -- Deploying from SSDT -- Deploying from the Command Line -- Deployment Failures -- Conclusion -- Chapter 5: Configure the SSIS Catalog Project -- Configuring Projects -- Configuring Connections -- Overriding the Connection Configuration -- Externalizing the Connection Configuration -- Creating an Environment -- Configuring an Environment -- Configuring a Reference -- Configuring a Reference Mapping -- Testing the Configuration -- Conclusion -- Chapter 6: Catalog Browser -- Why I Built DILM Suite, by Andy Leonard -- Surfacing the SSIS Catalog -- SSIS Catalog Environment Configuration -- SSIS Catalog Project Configuration -- Catalog Browser -- Conclusion -- Chapter 7: SSIS Catalog Compare -- Why I Built SSIS Catalog Compare, by Andy Leonard -- SSIS Catalog Compare -- Expanding the Differences -- Catalog Properties -- SSIS Catalog Compare Scripting -- Creating a Catalog Folder -- Deploying the SSIS Project -- Deploying the Literal Overrides and Catalog Environment -- Deploying Project and Package References.

Testing with SSIS Catalog Compare -- Chapter 8: SSIS Framework Community Edition -- SSIS Framework Community Edition -- Help for SSIS Catalog Projects Already Deployed -- Viewing SSIS Catalog Reports -- Viewing SSIS Framework Community Edition Metadata -- Chapter 9: Catalog Reports -- Chapter 10: BimlExpress Metadata Framework -- Downloading and Installing BimlExpress -- Downloading BimlExpress Metadata Framework -- Following the README File Instructions -- Restoring the BimlMetadata Database -- Updating the Connection String Variable Value in the Params.biml File -- Updating the di.Connections Table -- Generating the Destination Database -- Generating the Destination Schemas -- Generating the Destination Tables -- Executing the Create-Destination-Artifacts SSIS Packages -- Deleting Existing Artifacts -- Generating SSIS Packages -- Executing the Controller -- Validating the Load -- Full Circle -- Chapter 11: Conclusion -- Appendix A: Links -- Erratum -- Index.

Description based on publisher supplied metadata and other sources.

Electronic reproduction. Ann Arbor, Michigan : ProQuest Ebook Central, 2024. Available via World Wide Web. Access may be limited to ProQuest Ebook Central affiliated libraries.