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 » ETL » SQL Server » SSIS   (RSS)
  • SQL Server 2017 Integration Services Cookbook

    I coauthored my 15th book Together with Christian Cote (lead author) and Matija Lah (coauthor) we publishes SQL Server 2017 Integration Services Cookbook. Of course, it is kind of early to say this is a definitive guide to SSIS 2017. More accurate name would be SSIS 2016 / 2017 Cookbook. Besides detailed guidelines how to use the 2016 version, you ...
    Posted to Dejan Sarka (Weblog) by Dejan Sarka on July 14, 2017
  • Precon - SSIS Design Patterns and BIML: A Day of Intelligent Data Integration–8 Jan 2016, Alpharetta Georgia

            I’m excited to announce I will be delivering a precon 8 Jan 2016 in Alpharetta Georgia for SQL Saturday 477 – Atlanta BI Edition titled SSIS Design Patterns and BIML: A Day of Intelligent Data Integration! This precon is all about DILM (Data integration Lifecycle Management). Abstract: SSIS Design ...
    Posted to Andy Leonard (Weblog) by andyleonard on November 12, 2015
  • I Am Here To Help™

    Introduction This isn’t a trick. It’s not a gimmick. It’s not bait-and-switch. It is selfish; please allow me to explain: I Am Here To Help™ This has been my motto for the past few years. How can I serve you today? Are you thinking about starting a User Group and don’t know where to begin? I can help. Are you planning an event and encountering ...
    Posted to Andy Leonard (Weblog) by andyleonard on August 19, 2011
  • Presenting at Hampton Roads SQL Server and SharePoint Users Group Tomorrow!

    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 ...
    Posted to Andy Leonard (Weblog) by andyleonard on July 19, 2011
  • Try-N-Save SSIS Packages

    The Try-N-Save SSIS Packages from my SSIS Dimensional Data Optimization presentation are available at http://cid-8f7e6c950afc6b3e.office.live.com/self.aspx/.Public/Presentation/TryNSave.zip. I'm still working on getting the sample database uploaded - even compressed a backup is larger than SkyDrive's upload filesize limit. I'll script it out when ...
    Posted to Michael Coles: Sergeant SQL (Weblog) by Mike C on November 29, 2010
  • SSIS: Mo' Secure Configurations

    I ran into an issue the other day and I needed a solution for automically configuring my SSIS packages from securely stored DBMS connection strings. Problem is that most DBMSs don’t support Integrated Authentication—they require a username and password. Storing the username/password combo in the connection string in plain text is a security risk, ...
    Posted to Michael Coles: Sergeant SQL (Weblog) by Mike C on January 18, 2010
  • A Day of SSIS Training 15 Oct 2009 at SQL Saturday #21 Orlando

    I'm honored to be presenting a day of SSIS training entitled From Zero To SSIS on 15 Oct 2009 - the Thursday before SQLSaturday #21 (17 Oct 2009) in Orlando. I'm so excited about the opportunity! I've personally taught hundreds of developers to use SSIS and wrote courseware used to train even more. In this course, I use real-world data ...
    Posted to Andy Leonard (Weblog) by andyleonard on August 25, 2009
  • New SSIS 101 Article

    My latest SSIS 101 article - SSIS 101: Object Variables, ResultSets, and Foreach Loop Containers - is live at SQL Server Central today! Enjoy! :{> Andy
    Posted to Andy Leonard (Weblog) by andyleonard on August 21, 2008
Privacy Statement