Search results matching tags 'Design Pattern', 'SSIS', and 'Presentations'

Join the Authors of SSIS Design Patterns at the PASS Summit 2012!

andyleonard — Wed, 19 Sep 2012 09:00:00 GMT

My fellow authors and I will be presenting a day-long pre-conference session titled SSIS Design Patterns at the PASS Summit 2012 in Seattle Monday 5 Nov 2012!

Package execution
Package logging
Loading flat file sources
Loading XML sources
Loading the cloud
Dynamic package generation
SSIS Frameworks
Data warehouse ETL
Data flow performance

Presenting this session:

I hope to see you in Seattle! If you read this blog and attend our session or see me wandering around, please introduce yourself. I am the fat guy with a fu.

:{>

Presenting at Ohio North SQL Server User Group 1 May 2012!

andyleonard — Fri, 20 Apr 2012 15:01:00 GMT

I am honored to present Using BIML as an SSIS Design Patterns Engine to the Ohio North SQL Server User Group 1 May 2012! This presentation is based on one of my favorite chapters in the upcoming book: SSIS Design Patterns scheduled for release this summer.

If you find yourself in the Cleveland area on the evening of 1 May, please drop by and introduce yourself. I am the fat guy with a fu.

:{>

Updated SSIS Framework, Now Includes Reports

andyleonard — Wed, 07 Mar 2012 12:00:00 GMT

I have built a beta version of Linchpin People’s SSIS Framework, now including much-requested reports. You can grab the updated copy here.

I appreciate any feedback you care to share.

:{>

Designing an SSIS Framework

andyleonard — Fri, 16 Sep 2011 11:00:00 GMT

In preparation for SQL Saturday #84 – Kalamazoo, SQLBits 9, and the PASS Summit 2011; I’ve been honing my presentation called Designing an SSIS Framework. I delivered this presentation a few times over the past couple months. Each time, I promised the attendees I’d send them the code if they emailed me… and a couple things got in the way:

First, a lot of people requested the presentation. Second, I got really busy! Both of those beat their respective alternatives.

I finished building and barely testing the code this evening. You can grab an updated copy here. The zip file contains the SSIS 2008 R2 solution and two other folders: Config and Sql. Config holds a configuration file that points to a database named SSISConfig on the default instance of your local workstation or server (edit SSISConfigParent.dtsConfig if you want to change this location).

To make it all work dynamically, you need to create a System Environment Variable named SSISConfig (case-sensitive) and set the value to the full path of SSISConfigParent.dtsConfig on your workstation or server. Next, run the “Create SSISConfig.sql” script in the Sql folder, followed by the “Add An SSIS Applications.sql” script (edited to reflect the folder that contains the SSIS packages on your workstation or server). This should get everything ready for the SSISConfig SSIS solution. When you execute Parent.dtsx, it should call Template1.dtsx, then Template2.dtsx, and finally ErrorTest.dtsx.

Let me know how it goes!

:{>

Presenting at SQL Saturday #84–Kalamazoo 17 Sep 2011!

andyleonard — Wed, 07 Sep 2011 21:00:00 GMT

Introduction

I am honored to present Designing an SSIS Framework and “I See a Control Flow. Now What?” at SQL Saturday #84 in Kalamazoo Michigan 17 Sep 2011!

I See a Control Flow. Now What?

This highly-interactive, demo-intense presentation is for beginners and developers just getting started with SSIS. Attend and learn how to build SSIS packages from the ground up.

Designing an SSIS Framework

In this “demo-tastic” presentation, SSIS trainer, author, and consultant Andy Leonard explains the what, why, and how of an SSIS framework that delivers metadata-driven package execution, connections management, and centralizes logging. Key takeaways: 1) Developers can migrate packages from Development, through their lifecycle, to Production without editing SSIS Connection Managers properties. 2) A metadata-driven approach to SSIS package execution. 3) Demonstration of a centralized logging reporting application.

Conclusion

If you will be attending SQL Saturday #84 and read this blog, please introduce yourself! I’m the fat guy with a fu…

:{>

Presenting at Hampton Roads SQL Server and SharePoint Users Group Tomorrow!

andyleonard — Tue, 19 Jul 2011 16:58:14 GMT

I am honored to present Designing an SSIS Framework to Hampton Roads SQL Server and SharePoint Users Group tomorrow, 20 Jul 2011! You can register here.

Details:

Infotec
100 Constitution Dr
Virginia Beach, VA 23462

Wednesday, July 20, 2011 at 6:30 PM (ET)

If you read this blog and will be there, introduce yourself! I’m the fat guy with a fu.

:{>

Speaking at the Charlotte SQL Server Users Group Wednesday 18 May!

andyleonard — Mon, 16 May 2011 12:30:00 GMT

I am honored to present SSIS Design Patterns to the Charlotte SQL Server Users Group Wednesday, 18 May 2011! If you read this blog and will be in the area Wednesday, stop by and say Hi!

:{>

Presenting at Roanoke Code Camp Saturday!

andyleonard — Mon, 07 Mar 2011 17:00:00 GMT

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 developers just getting started with SSIS. Attend and learn how to build SSIS packages from the ground up.

Designing an SSIS Framework

I'm also presenting a Level 400 talk about designing an SSIS Framework.
In this “demo-tastic” presentation, SSIS trainer, author, and consultant Andy Leonard explains the what, why, and how of an SSIS framework that delivers metadata-driven package execution, connections management, and centralizes logging. Key takeaways: 1) Developers can migrate packages from Development, through their lifecycle, to Production without editing SSIS Connection Managers properties. 2) A metadata-driven approach to SSIS package execution. 3) Demonstration of a centralized logging reporting application.

Conclusion

If you're going to be near Roanoke Virginia Saturday 12 Mar, register! I hope to see you Saturday!

:{>

Presenting Designing an SSIS Execution Framework to Steel City SQL 18 Jan 2011!

andyleonard — Wed, 12 Jan 2011 12:00:00 GMT

I'm honored to present Designing an SSIS Execution Framework (Level 300) to Steel City SQL - the Birmingham Alabama chapter of PASS - on 18 Jan 2011!

The meeting starts at 6:00 PM 18 Jan 2011 and will be held at:

New Horizons Computer Learning Center
601 Beacon Pkwy. West
Suite 106
Birmingham, Alabama, 35209 (Map for directions)

Abstract
In this “demo-tastic” presentation, SSIS trainer, author, and consultant Andy Leonard explains the what, why, and how of an SSIS framework that delivers metadata-driven package execution, connections management, and centralizes logging. Key takeaways: 1) Developers can migrate packages from Development through their life cycle to Production without editing SSIS Connection Manager properties. 2) A metadata-driven approach to SSIS package execution. 3) Demonstration of a centralized logging reporting application.

Meeting organizers request attendees RSVP to steelcitysql@gmail.com so they'll know how much food to bring. If you read this blog and are in the area Tuesday evening, stop by and introduce yourself!

I hope to see you there!

:{>

Presenting SSIS Design Patterns to Roanoke Valley SQL Server UG Tomorrow!

andyleonard — Tue, 11 Jan 2011 12:00:00 GMT

I am honored to present SSIS Design Patterns to the newly re-formed Roanoke Valley SQL Server Users Group Wednesday, 12 Jan 2011!

The meeting starts at 6:00 PM ET and will be held at:

Blue Ridge Library
28 Avery Row
Roanoke, VA 24012 (Map)

If you read this blog and will be in the area, stop by and introduce yourself!

:{>