000 04549nam a22004333i 4500
001 EBC5149912
003 MiAaPQ
005 20240729131603.0
006 m o d |
007 cr cnu||||||||
008 240724s2017 xx o ||||0 eng d
020 _a9781484232767
_q(electronic bk.)
020 _z9781484232750
035 _a(MiAaPQ)EBC5149912
035 _a(Au-PeEL)EBL5149912
035 _a(CaPaEBR)ebr11467767
035 _a(OCoLC)1012882784
040 _aMiAaPQ
_beng
_erda
_epn
_cMiAaPQ
_dMiAaPQ
050 4 _aQA76.9.D3
100 1 _aLeonard, Andy.
245 1 0 _aData Integration Life Cycle Management with SSIS :
_bA Short Introduction by Example.
250 _a1st ed.
264 1 _aBerkeley, CA :
_bApress L. P.,
_c2017.
264 4 _c©2018.
300 _a1 online resource (189 pages)
336 _atext
_btxt
_2rdacontent
337 _acomputer
_bc
_2rdamedia
338 _aonline resource
_bcr
_2rdacarrier
505 0 _aIntro -- 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.
505 8 _aTesting 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.
588 _aDescription based on publisher supplied metadata and other sources.
590 _aElectronic reproduction. Ann Arbor, Michigan : ProQuest Ebook Central, 2024. Available via World Wide Web. Access may be limited to ProQuest Ebook Central affiliated libraries.
650 0 _aDatabase management.
650 0 _aData integration (Computer science).
655 4 _aElectronic books.
776 0 8 _iPrint version:
_aLeonard, Andy
_tData Integration Life Cycle Management with SSIS
_dBerkeley, CA : Apress L. P.,c2017
_z9781484232750
797 2 _aProQuest (Firm)
856 4 0 _uhttps://ebookcentral.proquest.com/lib/orpp/detail.action?docID=5149912
_zClick to View
999 _c132653
_d132653