Author:Andy Leonard

I had an awesome time sharing about Biml (Business Intelligence Markup Language) earlier today! Thank you to everyone who registered and turned out for the live presentation. For those unable to make it to the live presentation, the recording is now available for viewing. I’ve posted the Mist and SSIS solutions source code. You can …
Continue reading Biml 101 Recording and Files Are Now Available!

One of the coolest features of the SSIS Catalog is Catalog Environments. Catalog Environments offer a compelling and rich solution for Catalog Project Parameter value externalization and configuration management, whether the parameters are connections or parameter values. Configuring and using Catalog Environments involves four steps: Create the Catalog Environment Create and Configure the Catalog Environment …
Continue reading Managing SSIS Catalog Project Parameter Values

A reader emailed to ask what I recommend for learning current software and database development. I responded with these links: VirtualBox Windows 2016 Server TP3 SQL Server 2016 CTP 3 Visual Studio 2015 I believe the software is all free, though it is a combination of community and (time-limited) technology previews. Save your code in …
Continue reading November 2015–Learn SQL Server and Visual Studio

        I’m excited to announce I will be delivering a precon 8 Jan 2016 in Alpharetta Georgia for SQL Saturday 477 – Atlanta BI Edition titled SSIS Design Patterns and BIML: A Day of Intelligent Data Integration! This precon is all about DILM (Data integration Lifecycle Management). Abstract: SSIS Design Patterns and Biml: A Day …
Continue reading Precon – SSIS Design Patterns and BIML: A Day of Intelligent Data Integration–8 Jan 2016, Alpharetta Georgia

An Overview of SSIS Variables – Step 13 of the Stairway to Integration Services is a featured article this morning at SQL Server Central. Enjoy! :{>

One of the most anticipated features of SQL Server 2016 Integration Services (SSIS 2016) is support for deploying a single SSIS package from an SSIS project. “Why Is This A Big Deal, Andy?” I’m glad you asked. Consider the following scenario: You deploy version 1 of an SSIS Project containing 20 SSIS Packages to Production. …
Continue reading SSIS 2016 Supports Single-Package Deployment

If you’ve heard the buzz about Business Intelligence Markup Language (Biml) but never used it, you may be curious about how Biml works and how it can help reduce the amount of time required to develop SSIS packages. In this 100-level presentation, BimlHero Andy Leonard demonstrates how to use Biml to build an SSIS package. …
Continue reading Biml 101 – A Free Webinar 18 Nov 1:00 PM EST

I was reminded today (again) that I need to blog about the SYNCHRONIZED SSIS execution parameter. I mentioned it last week while presenting at the PASS Summit 2015 and made a mental note to blog soon. Earlier today, as I was discussing features of the SSIS Catalog Compare utility, the topic came up again. Credit …
Continue reading The SYNCHRONIZED SSIS Execution Parameter

I probably did something dumb to cause this, but on the off chance it’s not (just) me I thought I would blog about it. I’ve been tinkering with SSIS 2016 in SQL Server 2016 CTP3. I set up a VM running Windows Server 2012 and installed the CTP along with SQL Server Data Tools for …
Continue reading VSTA Script Editor Not Displaying in VS2015 / SSIS 2016

After a couple long naps Saturday and Sunday, I’m almost caught up on sleep from last week. Ok, not really. But we were out really late most nights last week. As I told some people, “It has been dark for a couple hours already!” The PASS Summit is always a time for #SQLFamily to come …
Continue reading #sqlcares