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 » BimlScript   (RSS)
Showing page 1 of 3 (22 total posts)
  • 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
  • I’m Presenting Biml and SSIS Execution Frameworks at RichmondSQL 9 Jun!

    I am honored to present Biml and SSIS Execution Frameworks 9 Jun 2016 at the Richmond SQL Server Users Group! The meeting starts at 6:30 PM EDT and will be held at 4600 Cox Rd in Glen Allen, VA. Biml and SSIS Execution Frameworks You’ve probably heard that it’s a data integration best practice to build small, unit-of-work SSIS packages. ...
    Posted to Andy Leonard (Weblog) by andyleonard on May 26, 2016
  • I’m Presenting Biml and SSIS Execution Frameworks at CharlotteSQL 8 Jun 2016!

    I am honored to present Biml and SSIS Execution Frameworks 8 Jun 2016 at the Charlotte SQL Server User Group! To learn more about meetings at the Charlotte SSUG sign up for their newsletter or follow them on Facebook, Twitter, and LinkedIn. Biml and SSIS Execution Frameworks You’ve probably heard that it’s a data integration best practice to ...
    Posted to Andy Leonard (Weblog) by andyleonard on May 25, 2016
  • Announcing Biml Academy!

    Announcing Enterprise Data & Analytics Biml Academy – 5 Days of Free Training – 9-13 May! Welcome to Biml Academy! Join me for a five-day online event and learn Biml now! [Recording] Biml Academy – Lesson 0 – SSIS Design Patterns – Before we dive into code generation, let’s discuss and demonstrate some SSIS Design Patterns. ...
    Posted to Andy Leonard (Weblog) by andyleonard on March 30, 2016
  • Biml 103–Automating SSIS Design Patterns with Biml Recording is up!

    The Biml 103 webinar “Automating SSIS Design Patterns with Biml” recording is now available. Registration is required, but it’s free. Enjoy! :{>
    Posted to Andy Leonard (Weblog) by andyleonard on January 14, 2016
  • SSIS Design Patterns and BIML: A Day of Intelligent Data Integration

    I’m honored to deliver a brand new precon (the PowerPoint slides still have that new slide smell) at SQL Saturday #477 – Atlanta – BI Edition! The precon is titled SSIS Design Patterns and Biml: A Day of Intelligent Data Integration. Abstract Join Andy Leonard, founder of Enterprise Data & Analytics, SSIS coach and trainer, author, and ...
    Posted to Andy Leonard (Weblog) by andyleonard on December 21, 2015
1 2 3 Next >
Privacy Statement