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 5 of 7 (67 total posts)
  • T-SQL Tuesday: Aggregations in SSIS

      Introduction Jes Borland (Blog | @grrl_geek) is hosting this month's T-SQL Tuesday - started by SQLBlog's own Adam Machanic (Blog | @AdamMachanic) - and it is about aggregation. I thought I'd show a couple ways to do aggregation using SSIS. The Aggregate Transformation in SSIS The Aggregate transform in SSIS is fast. I ...
    Posted to Andy Leonard (Weblog) by andyleonard on March 8, 2011
  • Presenting at Roanoke Code Camp Saturday!

    Introduction I am honored to once again be selected to present at Roanoke Code Camp! An Introductory Topic One of my presentations is titled ''I See a Control Flow Tab. Now What?'' It's a Level 100 talk for those wishing to learn how to build their very first SSIS package. This highly-interactive, demo-intense presentation is for beginners and ...
    Posted to Andy Leonard (Weblog) by andyleonard on March 7, 2011
  • A Day of SSIS in May

    Introduction I could run through the abstract for my submission to the SQLRally pre-con - and I will include much of it in this post. But Wait There's More! It's difficult to convey in writing my passion for SQL Server Integration Services. I like the platform - a lot. I love sharing SSIS with others for a bunch of reasons; chief among ...
    Posted to Andy Leonard (Weblog) by andyleonard on November 1, 2010
  • SQLRally Pre-Conference Voting Is Open!

    SQLRally The SQLRally team has been working overtime and you can now vote on the pre-conference session you'd most like to see. What a great idea. This is a much better way to select pre-cons. This way, the SQL Server Community wins. I submitted a pre-conference session called A Day of SSIS. You can cast your vote here. A Day of ...
    Posted to Andy Leonard (Weblog) by andyleonard on October 26, 2010
  • Presenting Part 4 of Building a Scalable, Enterprise-Class Data Warehouse for SQL Server 20 Oct 2010

    I am honored to present Part 4 of 4 of Building a Scalable, Enterprise-Class Data Warehouse for SQL Server Wednesday, 20 Oct 2010! This presentation features a demo of expressor 3.0 studio by Steve Frechette, expressor's Vice President of Engineering. It's going to be fun and I hope to see you there! :{>
    Posted to Andy Leonard (Weblog) by andyleonard on October 15, 2010
  • Presenting at SQLLunch Today!

    I'm honored and excited to present SSIS Design Patterns 1c: Variables, Events, and Automated Custom Logging Patterns for SQLLunch today (11 Oct 2010)! In this talk, I cover building a custom logging solution in SSIS. I hope to see you there! :{>
    Posted to Andy Leonard (Weblog) by andyleonard on October 11, 2010
  • SQL Saturday #48 Recap

    Introduction I got to attend SQL Saturday #48 2 Oct 2010 and was honored to present. ''I'm Andy, and I'm a session-hopper.'' There. I said it. When I'm not presenting, I often wander between sessions. I want to learn a little something from everyone. Here are some sessions I wandered through and some notes from them: Alejandro Mesa - ...
    Posted to Andy Leonard (Weblog) by andyleonard on October 4, 2010
  • Presenting SSIS Design Patterns 1b: Incremental Loads and Parent-Child Patterns at SQLLunch Today!

    I am honored to present SSIS Design Patterns 1b: Incremental Loads and Parent-Child Patterns at SQLLunch today beginning at 12:30 PM EDT! This is part two of a three part series. (UPDATED)In this presentation, I walk through Incremental Load and Parent-Child SSIS design pattern basics. I also include a discussion of Change Detection in ETL. Hope ...
    Posted to Andy Leonard (Weblog) by andyleonard on September 13, 2010
  • SSIS is Case-Sensitive

    Introduction SSIS is case-sensitive even if the database is case-insensitive. Imagine...  ... you work in an ETL shop where someone who believes in natural keys won the Battle of the Joins. Imagine one of your natural keys is a string. (I know it's a stretch... play along!). Let's build some tables to sketch it out. If you do ...
    Posted to Andy Leonard (Weblog) by andyleonard on May 28, 2010
  • SSIS Design Pattern: Loading Variable-Length Rows

    Introduction I encounter flat file sources with variable-length rows on occasion. Here, I supply one SSIS Design Pattern for loading them. What's a Variable-Length Row Flat File? Great question - let's start with a definition. A variable-length row flat file is a text source of some flavor - comma-separated values (CSV), ...
    Posted to Andy Leonard (Weblog) by andyleonard on May 18, 2010
Privacy Statement