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 |