THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » SSIS » Elegant Design   (RSS)
  • Advanced SSIS Design Patterns and Automation with Biml PASS Essential Deutschland–15 Jun 2015!

    I am honored to deliver a full-day PASS Essential in Germany 15 Jun 2015! I’ll be sharing: Advanced SSIS Design Patterns and Automation with BIML Advanced SSIS Design Patterns for performance, support, and maintain-ability Data Flow performance patterns SSIS Catalog-integrated Execution Frameworks Connections and ...
    Posted to Andy Leonard (Weblog) by andyleonard on May 11, 2015
  • Little Data Remains Important in Healthcare IT

    In his article Healthcare's Big Problem With Little Data, author Dan Munro raises salient points about the state of health-related data. Electronic Health Records (EHR) were promoted as the end-all-be-all solution for the industry – a standardization that, I suppose, many thought would organically and naturally occur, stabilize, and be ...
    Posted to Andy Leonard (Weblog) by andyleonard on April 30, 2013
  • SSIS Snack: Name Those Connections!

    When creating Connection Managers in SSIS, take a moment to click the “All” page and set a value in the Application Name property. In SSIS 2008+, a default value is applied to this property. It’s useful but it contains a GUID. Yuck. I prefer to enter a more concise identifier like the one shown here:   “Why should I enter this ...
    Posted to Andy Leonard (Weblog) by andyleonard on February 9, 2012
  • How Many SSIS Packages Should I Create?

    Introduction   I received the following questions (paraphrased) from a friend:   I'm building an ETL process with SSIS in which I pull from about 40 tables in DB2. I put the data into staging tables in a SQL Server database. Is it better to have one package with 40 data flows, 40 packages with ...
    Posted to Andy Leonard (Weblog) by andyleonard on December 28, 2009
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement