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 » Data Integration   (RSS)
Showing page 1 of 3 (30 total posts)
  • Presenting Use Biml to Automate SSIS Design Patterns at #TriPASS 18 Apr!

    I’m honored to present Use Biml to Automate SSIS Design Patterns at the Triangle SQL Server User Group in Raleigh, NC 18 Apr 2017! …especially since I missed SQL Saturday – Raleigh last month due to illness. Abstract Perhaps you’ve heard the buzz about Business Intelligence Markup Language (Biml) and wondered, “Why is everyone so excited ...
    Posted to Andy Leonard (Weblog) by andyleonard on April 17, 2017
  • Data Wrangling Concepts: Latency and Staleness

    Latency is the amount of time between data creation and load. Staleness is the amount of time since data in a target was refreshed. In many data integration use cases, a latency or staleness of one day, one week, or even one month is acceptable. Enterprise Data & Analytics helps enterprise data integration teams reduce latency and staleness. ...
    Posted to Andy Leonard (Weblog) by andyleonard on April 13, 2017
  • Why Automate?

    Because, as Jen Underwood (jenunderwood.com | LinkedIn | @idigdata) states in an upcoming podcast: The future of data science is automation. If automation is the future, how do we decide what to automate? We look for the long pole. What’s the long pole in data science? Data Integration is the Long Pole According to Lars Nielsen in his book ...
    Posted to Andy Leonard (Weblog) by andyleonard on March 12, 2017
  • An Example of Data Integration Lifecycle Management with SSIS, Part 4

    In this post I will demonstrate advanced options for executing SSIS packages in the SSIS Catalog. I’ll also demonstrate SSIS Catalog Browser, SSIS Framework Community Edition, Framework Browser, and Catalog Reports – free utilities and solutions from DILM Suite that may help as you implement your enterprise Data Integration Lifecycle Management ...
    Posted to Andy Leonard (Weblog) by andyleonard on January 29, 2017
  • The Recording for Advanced SSIS Execution is Available

    The recording for the Enterprise Data & Analytics webinar titled Advanced SSIS Execution is now available (registration required). Enjoy! :{> Learn More: SSIS Catalog Compare v2.0 Launch Event 7 Mar 2017! SSIS Catalog Management SSIS Lifecycle Management Related Training: IESSIS1: Immersion Event on Learning SQL Server ...
    Posted to Andy Leonard (Weblog) by andyleonard on January 24, 2017
  • An Example of Data Integration Lifecycle Management with SSIS, Part 3

    In this post I will demonstrate how to use SSIS Catalog Environments, References,  and Reference Mappings to override SSIS parameter values at execution time. There three sources of SSIS parameter values: Design-time defaults – these are the parameter values developers use when building the SSIS project and packages. SSIS ...
    Posted to Andy Leonard (Weblog) by andyleonard on January 22, 2017
  • An Example of Data Integration Lifecycle Management with SSIS, Part 2

    In this post I will demonstrate how to use the SSIS Catalog to execute and monitor an SSIS project. Manual SSIS Package Execution in the SSIS Catalog To execute an SSIS Package manually using the SSIS Catalog, connect to the SQL Server instance that hosts the Catalog using SQL Server Management Studio (SSMS). Once connected, open Object Explorer ...
    Posted to Andy Leonard (Weblog) by andyleonard on January 15, 2017
  • The Recording for SSIS Catalog Management is Available

    The recording for the Enterprise Data & Analytics webinar titled “SSIS Catalog Management” is now available (registration is required). In the SSIS Academy: Using the SSIS Catalog series, Kent and I walked through the SSIS Catalog functionality built into SQL Server Management Studio (SSMS). This webinar picks up where SSIS Academy: Using the ...
    Posted to Andy Leonard (Weblog) by andyleonard on January 11, 2017
  • An Example of Data Integration Lifecycle Management with SSIS, Part 1

    In this post I will provide some details about the demo SSIS project. I will then focus on version control and deployment. What DILM Is and Is Not Data Integration Lifecycle Management (DILM) is not about data integration development. DILM is about everything else: Configurations Management Version Management ...
    Posted to Andy Leonard (Weblog) by andyleonard on January 8, 2017
  • Announcing SSIS Catalog Compare and CatCompare Version 2

    I am pleased to announce the release of SSIS Catalog Compare and CatCompare version 2. You can purchase a bundle that includes both products (and saves you some money) or can purchase each product separately: SSIS Catalog Compare and CatCompare. If you’re interested in learning more about the functionality provided by the products you can ...
    Posted to Andy Leonard (Weblog) by andyleonard on January 6, 2017
1 2 3 Next >
Privacy Statement