Automating SSIS Package Generation Using Biml Technology
Discover how Biml, the Business Intelligence Markup Language, revolutionizes the automation of SQL scripts, SSIS packages, and SSAS cubes. Learn how to utilize Biml to streamline data solutions effortlessly.
Download Presentation
Please find below an Image/Link to download the presentation.
The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author. If you encounter any issues during the download, it is possible that the publisher has removed the file from their server.
You are allowed to download the files provided on this website for personal or commercial use, subject to the condition that they are used lawfully. All files are the property of their respective owners.
The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author.
E N D
Presentation Transcript
USING BIML TO AUTOMATE THE GENERATION OF SSIS PACKAGES Simon Kingaby skingaby@bmi.com
WHAT YOU WILL SEE IN THE NEXT HOUR Actual Biml Code Actual Metadata Actual SSIS Package Generation
WHAT IS BIML? Only the most amazing development in SSIS package generation ever Business intelligence markup language (Biml) is a programming language for creating and automating data solutions Biml uses XML and small nuggets of C# or VB code to automatically create huge amounts of SQL scripts, SSIS packages, and SSAS cubes.
HOW DO I GET THIS INCREDIBLE TOOL? For SQL Server 2012 and earlier, get the relevant BIDS Helper version from https://bidshelper.codeplex.com/ For SQL server 2014 and later, use VS 2015 and get the Biml Express plug-in from varigence.com/bimlexpress Use BimlOnline Get Mist/BimlStudio from varigence.com
DEMO! My first Biml script Some metadata tables Some C# code My second Biml script Package generation My third Biml script
