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 » ETL   (RSS)
Showing page 1 of 7 (68 total posts)
  • Presenting Use Biml to Automate SSIS Design Patterns at #TriPASS 18 Apr!

    I’m honored to present Use Biml to Automate SSIS Design Patterns at the Triangle SQL Server User Group in Raleigh, NC 18 Apr 2017! …especially since I missed SQL Saturday – Raleigh last month due to illness. Abstract Perhaps you’ve heard the buzz about Business Intelligence Markup Language (Biml) and wondered, “Why is everyone so excited ...
    Posted to Andy Leonard (Weblog) by andyleonard on April 17, 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
  • Free Webinar: Loading Medical Data to the Cloud

    Join Andy Leonard and Kent Bradshaw of Enterprise Data & Analytics 11 Aug 2016 at 1:00 PM EDT as we discuss and demonstrate strategies for loading medical data to the Microsoft Azure SQL DB with SQL Server Integration Services (SSIS). Register today! :{>
    Posted to Andy Leonard (Weblog) by andyleonard on July 25, 2016
  • Announcing Biml Academy!

    You can access Biml Academy recordings and more at the Biml Academy website! 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 ...
    Posted to Andy Leonard (Weblog) by andyleonard on March 30, 2016
  • Easy SSIS Migration with SSIS Catalog Compare Recording is Available!

    The recording for the webinar titled Easy SSIS Migration with SSIS Catalog Compare is now available! Enjoy! :{>
    Posted to Andy Leonard (Weblog) by andyleonard on February 15, 2016
  • SSIS 2016 CTP 3 and Data Flow Column LineageID

    Back When We Used to Carve Our Own Chips Out of Wood… Back in the old days (2005), SSIS Data Flow LineageIDs were created at design-time. Here’s a screenshot of an SSIS 2005 package’s XML: When an error occurred, the ID property of the column in error was supplied to the ErrorColumn column field of the Error Output, as shown here: Although ...
    Posted to Andy Leonard (Weblog) by andyleonard on February 8, 2016
  • More Training from Andy Leonard!

    First, thanks to everyone who has attended one of my free webinars! I enjoy delivering training and hope that it shows. Where can you learn about upcoming training from me? At the Enterprise Data & Analytics Training page, of course. Upcoming training January 20 – Free Webcast: DILM DevOps: SSIS Frameworks + Design Patterns ...
    Posted to Andy Leonard (Weblog) by andyleonard on January 19, 2016
  • Managing SSIS Catalog Project Parameter Values

    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: ...
    Posted to Andy Leonard (Weblog) by andyleonard on November 18, 2015
  • Precon - SSIS Design Patterns and BIML: A Day of Intelligent Data Integration–8 Jan 2016, Alpharetta Georgia

            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 ...
    Posted to Andy Leonard (Weblog) by andyleonard on November 12, 2015
  • #Biml at the PASS Summit 2015

    I’m excited that PASS included Biml in the Summit 2015 this year. It’s the first year for this topic, at least officially. Unofficially, Biml topics have been presented the past couple years. The technology is maturing and receiving the exposure it so richly deserves. I’m honored be presenting Use Biml to Automate SSIS Design Patterns [BIA-401] ...
    Posted to Andy Leonard (Weblog) by andyleonard on October 25, 2015
1 2 3 4 5 Next > ... Last »
Privacy Statement