|
|
|
|
Andy Leonard is CSO of Linchpin People and SQLPeople, an SSIS Trainer, Consultant, and developer; SQL Server database and data warehouse developer, community mentor, engineer, and farmer. He is a co-author of SQL Server 2012 Integration Services Design Patterns. His background includes web application architecture and development, VB, and ASP. Andy loves the SQL Server Community!
March 2010 - Posts
-
I'm honored to join Glen Gordon ( Blog - @glengordon ) and G. Andrew Duthie ( Blog - @devhammer ) today at 3:00 PM EDT for an MSDN Webcast entitled GeekSpeak: Inside SQL Server Integration Services (SSIS). This is a LiveMeeting and you can join in the Read More...
|
-
Introduction Configuring a Source Adapter in a Data Flow Task couples (binds) the Data Flow to an external schema. This has implications for dynamic data loads. "Why Can't I...?" I'm often asked a question similar to the following: "I have 17 flat files Read More...
|
-
Introduction Every now and then, everyone needs a break. How do we respond when community leaders need a break? How should we respond? It's Normal People are cyclic animals - humans are diurnal by nature. We eat at regular intervals and are most comfortable Read More...
|
-
Introduction This post is the sixteenth part of a ramble-rant about the software business. The current posts in this series are: Goodwill, Negative and Positive Visions, Quests, Missions Right, Wrong, and Style Follow Me Balance, Part 1 Balance, Part Read More...
|
-
No it's not 1 Apr. Joel Spolsky ( Blog - @spolsky ) announced recently he is retiring from blogging 17 Mar 2010 . Reading Joel on Software always makes me think. Mr. Spolsky pioneered a writing style. Along the way he empowered developers, encouraging Read More...
|
-
Introduction The PASS Board, continuing a trend of more openness championed by Board members, released the results of its Location Survey . Along with this, PASS President Rushabh Mehta added a blog post explaining the interpretation and logic behind Read More...
|
-
I'm excited to present Applied SSIS Design Patterns to the Triangle SQL Server User Group 16 Mar 2010! This is a reprise of my PASS Summit 2009 spotlight session. If you read this blog and make the meeting, introduce yourself! :{> Andy Read More...
|
-
Another quick survey question, slightly off-topic: How's your economy? Have things picked up for you recently? Slowed down? Remained static? :{> Andy Read More...
|
-
One or two quick survey questions: Do you manage T-SQL scripts in source control? If so, which source control product / platform do you use? :{> Andy Note: I moderate comments, so your comment will take some time to publish. Read More...
|
-
Introduction SSIS Data Viewers are handy - very handy. I use them so much the Data Viewer link on my Data Flow Path context menu is showing signs of wear. I click on it that much. Using the Grid Data Viewer I'm starting with the Data Flow I built for Read More...
|
-
Introduction I am presenting today at SQL Saturday #33 in Charlotte, NC. Peter Shire and the other organizers have really outdone themselves. In my opinion, this event raises the bar for SQL Saturday events and elevates this particular event to the regional Read More...
|
-
Introduction This post is the fifteenth part of a ramble-rant about the software business. The current posts in this series are: Goodwill, Negative and Positive Visions, Quests, Missions Right, Wrong, and Style Follow Me Balance, Part 1 Balance, Part Read More...
|
-
Introduction Our friends at Sqlis.com created a Data Flow Component I use an awful lot when building SSIS packages: the Trash Destination Adapter . Adding to the Toolbox After downloading and installing the version you wish to use, right-click the SSIS Read More...
|
-
Introduction An easy-to-overlook function in an OLE DB Source adapter is the Preview button. Dummy Data To tinker with the Preview button, let's first create some dummy data in a Data Flow Task. There are a couple ways to create dummy data in a Data Flow, Read More...
|
-
Introduction This post is the fourteenth part of a ramble-rant about the software business. The current posts in this series are: Goodwill, Negative and Positive Visions, Quests, Missions Right, Wrong, and Style Follow Me Balance, Part 1 Balance, Part Read More...
|
-
Introduction This SSIS Snack is a continuation of a couple previous SSIS Snacks: SSIS Snack: Configuring an SSIS 2005 Lookup Transformation for a Left Outer Join (please see the clarification SSIS Snack: SSIS 2005 Lookup Transformations 101 ) SSIS Snack: Read More...
|
|
|
|
|
|