Enjoy this recording of the Updates to the SSIS Framework free webinar, delivered 30 Jul 2020 at 12:00 PM EDT. Learn more about the SSIS Framework at DILM Suite. Need Help Getting Started with SSIS? Enterprise Data & Analytics specializes in helping enterprises modernize their data engineering by lifting and shifting SSIS from on-premises to the cloud. Our …
Continue reading Recording for Updates to the SSIS Framework Webinar
Category:DILM Suite
Free Webinar – Updates to the SSIS Framework
Join me 30 Jul 2020 at 12:00 PM EDT for Updates to the SSIS Framework! The recording for this presentation is available here. “I cover a really good example in the webinar. “ My favorite new feature is Application Package Property Overrides. I can hear you thinking, “What are Application Package Property Overrides, Andy?” I’m …
Continue reading Free Webinar – Updates to the SSIS Framework
The Recording for Building an SSIS Framework in Azure Data Factory
Enjoy this recording of the (free!) Enterprise Data & Analytics webinar titled Building an SSIS Framework in ADF! :{> Need Help Getting Started with ADF? Enterprise Data & Analytics specializes in helping enterprises modernize their data engineering by lifting and shifting SSIS from on-premises to the cloud. Our experienced engineers grok enterprises of all sizes. We’ve done the hard work …
Continue reading The Recording for Building an SSIS Framework in Azure Data Factory
SQL Server Data Automation through Frameworks Book Available for Pre-Order
Although the cover image needs an update, my and Kent Bradshaw’s next book – titled “SQL Server Data Automation through Frameworks: Building Metadata-driven Frameworks with T-SQL, SSIS, and Azure Data Factory” is available for pre-order!
Free Webinar – Building an SSIS Framework in ADF
Join me at 12:00 PM EDT on 9 Jul 2020 for Building an SSIS Framework in ADF, another free Summer o’ ADF webinar from Enterprise Data & Analytics. Abstract Andy authors SSIS frameworks according to a few principles: 1. Functionality 2. Empathy 3. Simplicity Join Microsoft Data Platform MVP Andy Leonard as he discusses and …
Continue reading Free Webinar – Building an SSIS Framework in ADF
The SSIS Catalog and SCCPAC Files
The SSIS Catalog is a pretty cool SSIS framework, whether installed on-premises or in the cloud (Azure-SSIS). Practicing lifecycle management with the SSIS Catalog can be… challenging. Try scripting an existing SSIS Catalog Environment after creation, for example: The result? Sad trombone… SCCPAC Files to the Rescue! SSIS Catalog Compare Enterprise Edition includes SCCPAC file …
Continue reading The SSIS Catalog and SCCPAC Files
Azure DevOps and the SSIS Development Lifecycle Recording is Available!
Azure DevOps and the SSIS Development Lifecycle was recorded 3 Apr 2020. Enjoy! :{>
Free Training for People Who Have Lost Their Jobs
Update: I am unable to offer free training to people who lost their job due to the pandemic at this time. Thank you to everyone who took advantage of this offer. I hope the training helped. – Andy I saw a tweet earlier today from another friend who has been laid off as a …
Continue reading Free Training for People Who Have Lost Their Jobs
Source-Control SSIS Catalog Contents in Azure DevOps
I did a thing – actually a couple things – that I’ve been dreaming about for a while. In a couple recent blog posts – SSIS Catalog Compare Enterprise Generates SCCPAC Files and Azure DevOps, Software Development, and Git Part 4 – Command-Line with Azure DevOps – I walked through one way to source-control the …
Continue reading Source-Control SSIS Catalog Contents in Azure DevOps
Azure DevOps, Software Development, and Git Part 4 – Command-Line with Azure DevOps
I’m writing about my journey with git, sharing my experiences along the way. The series to date: Azure DevOps, SSIS, and Git Part 0 – Getting Started Azure DevOps, Software Development, and Git Part 1 – Applied Azure DevOps, Software Development, and Git Part 2 – Distributed Version Control Azure DevOps, Software Development, and Git …
Continue reading Azure DevOps, Software Development, and Git Part 4 – Command-Line with Azure DevOps