THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » SSIS » BIML   (RSS)
Showing page 1 of 4 (36 total posts)
  • Presenting Use Biml to Automate SSIS Design Patterns at SQL Saturday–Richmond!

    I’m honored to present Use Biml to Automate SSIS Design Patterns at SQL Saturday – Richmond 18 Mar 2017! The Biml Express Metadata Framework is the sample code for this presentation. It’s part of the DILM Suite. I hope to see you in Richmond! :{> Learn More: SSIS Design Patterns and Biml: A Day of Intelligent Data Integration – Boston ...
    Posted to Andy Leonard (Weblog) by andyleonard on February 22, 2017
  • Presenting Use Biml to Automate SSIS Design Patterns at SQL Saturday–Raleigh!

    I’m honored to present Use Biml to Automate SSIS Design Patterns at SQL Saturday – Raleigh 11 Mar 2017! You can download the sample code for this presentation at the DILM Suite website here. I hope to see you in Raleigh! :{> Learn More: SSIS Design Patterns and Biml: A Day of Intelligent Data Integration – Boston SQL Saturday precon, 24 ...
    Posted to Andy Leonard (Weblog) by andyleonard on February 21, 2017
  • Save Time and Improve SSIS Quality with Biml, A Free Webinar

    Join me at 1:00 PM EST 31 Jan 2017 for Save Time and Improve SSIS Quality with Biml, another free webinar from Enterprise Data & Analytics! “Save Time and Improve SSIS Quality with Biml” introduces Business Intelligence Markup Language (Biml) to SSIS developers, DBAs, sysadmins, and others who want to learn more about automating SSIS ...
    Posted to Andy Leonard (Weblog) by andyleonard on January 4, 2017
  • Presenting “Using Biml as an SSIS Design Patterns Engine” at the (605) SQL Server User Group 10 Jan

    I am honored to present – albeit remotely – Using Biml as an SSIS Design Patterns Engine to the (605) SQL Server User Group in Sioux Falls, SD Tuesday 10 Jan 2017! Perhaps you’ve heard the buzz about Business Intelligence Markup Language (Biml) and wondered, “Why is everyone so excited about Biml?” Occasionally, a new technology emerges that ...
    Posted to Andy Leonard (Weblog) by andyleonard on January 4, 2017
  • 2017 SQL Skills SSIS Immersion Events

    I’m home after a day of travel that included waking up at quarter-til-early to catch a cab to SeaTac with Tim Mitchell [blog | @Tim_Mitchell], bumpy flights, and a two-hour drive back to Farmville. We had a fantastic time! Our students asked lots of interesting questions and Tim and I were, I believe, able to answer them all (with a little help – ...
    Posted to Andy Leonard (Weblog) by andyleonard on September 24, 2016
  • I’m Presenting at SQL Saturday Charlotte (#560) Next Saturday!

    I’m honored and all giggly with anticipation about presenting at SQL Saturday 560 in Charlotte next Saturday, 17 Sep 2016! I’m presenting Biml and SSIS Frameworks, and I hope to see many of you there. For the SSIS Frameworks part of my presentation, I’m using SSIS Framework Community Edition, a free and open source SSIS Framework from Enterprise ...
    Posted to Andy Leonard (Weblog) by andyleonard on September 10, 2016
  • The Basics of Biml – the Execute SQL Task

    A couple years ago, I wrote a series of guest posts about the Basics of SSIS for my friend Pinal Dave’s [Blog | @pinaldave] popular blog, SQL Authority. In that series, I pointed out that I use only a handful of SSIS Control Flow tasks when designing SSIS packages. You can find the series here: Execute SQL Task Data Flow Task ...
    Posted to Andy Leonard (Weblog) by andyleonard on September 9, 2016
  • The Basics of Biml – Populating the Biml Relational Hierarchy

    In this post, I’m going to demonstrate how to build the objects Business Intelligence Markup Language (Biml) requires before creating anything – the Biml Relational Hierarchy. The Biml Relational Hierarchy provides the foundation for all relational interaction between packages, cubes, dimensions, facts, and T-SQL. It’s important to note that Biml ...
    Posted to Andy Leonard (Weblog) by andyleonard on September 6, 2016
  • Announcing Biml Academy 2!

    Biml Academy 2 – Lessons 5-9 – will be 15-19 Aug 2016. Each 1-hour session will begin at 1:00 PM EDT and will be recorded. Join Cathrine Wilhelmsen (blog), BimlHero and Microsoft Data Platform MVP, Scott Currie (creator of Biml and Mist), and me as we explore staging and loading data using SSIS packages generated by Biml. Monday 15 Aug: ...
    Posted to Andy Leonard (Weblog) by andyleonard on August 1, 2016
  • Use Biml to Remove Spaces from Flat File Column Names

    I hate a space in a database column name. Kent Bradshaw and I are updating our demo for loading National Provider Index (NPI) file data (We plan to present on this soon… more later…). The NPI files currently have 329 fields and almost every one of them contains spaces: I had 5 minutes, so I decided to fix it with Biml. I first created an SSIS ...
    Posted to Andy Leonard (Weblog) by andyleonard on July 6, 2016
1 2 3 4 Next >
Privacy Statement