using biml to automate ssis design patterns
TRANSCRIPT
![Page 1: Using BIML to automate SSIS Design Patterns](https://reader034.vdocuments.us/reader034/viewer/2022042707/589ac0c51a28abcf058b515f/html5/thumbnails/1.jpg)
Using Biml as an SSIS Design Patterns EngineAndy Leonard
https://www.linkedin.com/in/andyleonard
![Page 2: Using BIML to automate SSIS Design Patterns](https://reader034.vdocuments.us/reader034/viewer/2022042707/589ac0c51a28abcf058b515f/html5/thumbnails/2.jpg)
Automating SSIS Design Patterns
with BimlAndy Leonard
Data PhilosopherBimlHero
![Page 3: Using BIML to automate SSIS Design Patterns](https://reader034.vdocuments.us/reader034/viewer/2022042707/589ac0c51a28abcf058b515f/html5/thumbnails/3.jpg)
Agenda• Andy Who?• Biml Use Cases• Biml Relational Hierarchy• Biml as an SSIS Design Pattern Engine – 1 Pattern• Biml as an SSIS Design Pattern Engine – Multiple Patterns• Multiple Patterns Refactored• Resources
![Page 4: Using BIML to automate SSIS Design Patterns](https://reader034.vdocuments.us/reader034/viewer/2022042707/589ac0c51a28abcf058b515f/html5/thumbnails/4.jpg)
Andy Leonard (v1.0)• Dad• Developer• Author• Community Guy• BimlHero
![Page 5: Using BIML to automate SSIS Design Patterns](https://reader034.vdocuments.us/reader034/viewer/2022042707/589ac0c51a28abcf058b515f/html5/thumbnails/5.jpg)
Biml Use CasesWhy use Biml?When to not use Biml…When to use Biml…
![Page 6: Using BIML to automate SSIS Design Patterns](https://reader034.vdocuments.us/reader034/viewer/2022042707/589ac0c51a28abcf058b515f/html5/thumbnails/6.jpg)
Biml Relational HierarchyConnectionsDatabasesSchemasTablesColumns
![Page 7: Using BIML to automate SSIS Design Patterns](https://reader034.vdocuments.us/reader034/viewer/2022042707/589ac0c51a28abcf058b515f/html5/thumbnails/7.jpg)
Biml as an SSIS Design Patterns Engine
![Page 8: Using BIML to automate SSIS Design Patterns](https://reader034.vdocuments.us/reader034/viewer/2022042707/589ac0c51a28abcf058b515f/html5/thumbnails/8.jpg)
Biml in Action
Demo
![Page 9: Using BIML to automate SSIS Design Patterns](https://reader034.vdocuments.us/reader034/viewer/2022042707/589ac0c51a28abcf058b515f/html5/thumbnails/9.jpg)
Multiple Patterns – Metadata-Driven
![Page 10: Using BIML to automate SSIS Design Patterns](https://reader034.vdocuments.us/reader034/viewer/2022042707/589ac0c51a28abcf058b515f/html5/thumbnails/10.jpg)
Biml in Action
Demo
![Page 11: Using BIML to automate SSIS Design Patterns](https://reader034.vdocuments.us/reader034/viewer/2022042707/589ac0c51a28abcf058b515f/html5/thumbnails/11.jpg)
Multiple Patterns - Refactored
![Page 12: Using BIML to automate SSIS Design Patterns](https://reader034.vdocuments.us/reader034/viewer/2022042707/589ac0c51a28abcf058b515f/html5/thumbnails/12.jpg)
Biml in Action
Demo
![Page 14: Using BIML to automate SSIS Design Patterns](https://reader034.vdocuments.us/reader034/viewer/2022042707/589ac0c51a28abcf058b515f/html5/thumbnails/14.jpg)
Resources
Varigence.com BimlScript.com
BimlOnline.com
![Page 15: Using BIML to automate SSIS Design Patterns](https://reader034.vdocuments.us/reader034/viewer/2022042707/589ac0c51a28abcf058b515f/html5/thumbnails/15.jpg)
Resources
Stairway to Biml – http://sqlservercentral.com/stairway/100550/
![Page 16: Using BIML to automate SSIS Design Patterns](https://reader034.vdocuments.us/reader034/viewer/2022042707/589ac0c51a28abcf058b515f/html5/thumbnails/16.jpg)
Resources
Stairway to Integration Services – http://sqlservercentral.com/stairway/72494/
![Page 17: Using BIML to automate SSIS Design Patterns](https://reader034.vdocuments.us/reader034/viewer/2022042707/589ac0c51a28abcf058b515f/html5/thumbnails/17.jpg)
Thank You!Enterprise Data & Analytics
Please send feedback and questions to:[email protected]
@AndyLeonardlinkedin.com/in/andyleonard
@enterprise_dna