Search results matching tag 'SSIS Frameworks'

Announcing the 2013 Biml Workshop 15 Oct 2013 in Charlotte NC!

andyleonard — Sat, 18 May 2013 04:00:00 GMT

When:

October 15, 2013
8:45 am - 4:45 pm
Charlotte, NC

Where:

Wake Forest University Charlotte Center
200 North College Street
Charlotte, NC 28202

What:

Business Intelligence Markup Language (Biml) automates your BI patterns and eliminates the manual repetition that consumes most of your time. Come see why BI professionals around the world think Biml is the future of data integration and BI.

Registration is just $69. Register before July 15th and receive early bird discount of just $49. Breakfast, lunch, & refreshments are also included. Seating is limited. Register now to guarantee your spot.

:{>

Free Webinar - Using Enterprise Data Integration Dashboards

andyleonard — Tue, 20 Nov 2012 12:00:00 GMT

Join Kent Bradshaw and I as we present Using Enterprise Data Integration Dashboards Tuesday 11 Dec 2012 at 10:00 AM ET!

If data is the life of the modern organization, data integration is the heart of an enterprise. Data circulation is vital. Data integration dashboards provide enterprise ETL (Extract, Transform, and Load) teams near-real-time status supported with historical performance analysis. Join Linchpins Kent Bradshaw and Andy Leonard as they demonstrate and discuss the benefits of data integration dashboards.

Space is limited, so register today!

:{>

About Kent Bradshaw:
Kent Bradshaw is a SQL Server database/ETL developer and database architect. His background is in Medicaid claims, public school, government, retail and insurance systems. He was born in Richmond, Virginia and has remained in the area throughout his life. He attended the University of Richmond where he received a Bachelor degree in Information Systems as well as an Associate degree in Public Administration. In 2011, he founded Tudor Data Solutions LLC to pursue new development opportunities as well as join the family at Linchpin People. Outside of work, Kent enjoys spending time with his family, road trips with his wife, playing golf and laughing at the non-stop antics of his dog (and office assistant), Llian the Goldendoodle.

About Andy Leonard:
Andy Leonard is CSO of Linchpin People, an SSIS Trainer and Consultant, SQL Server database and Integration Services developer, SQL Server data warehouse developer, community mentor, blogger, and engineer. He is a co-author of SSIS Design Patterns. His background includes Visual Basic and web application architecture and development and SQL Server 2000-2012.

About Linchpin People:
Linchpin People LLC exists to create generations of technology entrepreneurs who are true servant leaders. We desire to serve our customers with integrity and skill. We are here to help and we strive to infuse the Golden Rule and love of God into every aspect of our business. Call us crazy but our goal is to change the world, one career, and one person at time.

Presenting Designing an SSIS Framework at NoVaSQL Monday!

andyleonard — Sat, 21 Jul 2012 02:12:12 GMT

I am honored to present Designing an SSIS Framework to the Northern Virginia SQL Server User Group Monday, 23 Jul 2012!

:{>

Presenting Designing an SSIS Framework at Wichita SQL Server User Group 21 Jun!

andyleonard — Wed, 13 Jun 2012 17:35:30 GMT

I am honored to present Designing an SSIS Framework to the Wichita SQL Server User Group 21 Jun 2012! If you are in the area and read this blog, stop 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.

:{>

MicroTraining Updates: SSIS Frameworks Redux and Mailing List

andyleonard — Wed, 21 Dec 2011 16:00:00 GMT

I am still learning. I attempted to capture my SSIS Frameworks Magic presentation yesterday. I partially succeeded with video and no audio, durnit! I am going to deliver the presentation again Tuesday, 27 Dec 2011 at 10:00 AM ET. I hope to capture video and audio this time. We shall see… You can register for the next event here.

If you are interested in receiving updates about future microTraining events, please join the mailing list.

:{>

MicroTraining Next Tuesday: SSIS Frameworks

andyleonard — Tue, 13 Dec 2011 16:41:00 GMT

I am not sure why, but Google+ Hangouts no longer work for microtraining. <sadface /> I found Meeting Burner a few weeks back and have switched to it. One cool feature? You can register for the meetings and add them to your calendar. Another cool feature? There are more than 10 seats.

Next Tuesday, 20 Dec, I am delivering MicroTraining on SSIS Frameworks. If you would like to learn more about SSIS Frameworks, please register here.

You can get the fully-functional demo code for this presentation by downloading the materials from this post.

I look forward to seeing you next Tuesday!

:{>

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!

:{>