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
Category:SSIS
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
SSIS Catalog Compare Enterprise Generates SCCPAC Files
SSIS Catalog Compare Enterprise Edition ships with the SCCPAC Deployment Wizard. The SCCPAC Deployment Wizard simplifies deploying the contents of an SSIS Catalog folder to an SSIS Catalog, whether on-premises or in the cloud: Configure SCCPAC File Location To configure the location for SCCPAC files, click View–>Options to open SSIS Catalog Compare’s Options dialog: Click …
Continue reading SSIS Catalog Compare Enterprise Generates SCCPAC Files
Announcing SSIS Data Flows and Administration Live, Online, Training Courses
I’m excited to announce fresh deliveries of two courses: 08-09 Apr 2020: SSIS Administration 13-14 Apr 2020: SSIS Data Flows Essentially, these courses are the first and second half of From Zero To SSIS. As I type (14 Mar 2020), both courses are on sale! Register for SSIS Data Flows or SSIS Administration today!These courses …
Continue reading Announcing SSIS Data Flows and Administration Live, Online, Training Courses
Four Free ADF Webinars
I just finished removing the latest appointment to attend an event from my calendar. A lot of awesome community events are being postponed or canceled. Let’s face it: the news stinks these days. What can we do about it? We can have free webinars online! Let’s Do This! Enterprise Data & Analytics is excited to …
Continue reading Four Free ADF Webinars
Updating Default SSIS Values in the SSIS Catalog
A couple friends recently contacted me trying to solve a similar issue: how to update parameter values stored in the SSIS Catalog. One of my friends was interested in migrating their SSIS Catalog to a new server and needed to update several default SSIS parameter values stored in the SSIS Catalog. My answer here consists …
Continue reading Updating Default SSIS Values in the SSIS Catalog
SSIS Extension 3.4 Available for Visual Studio 2019
The SSIS team announces the General Availability (GA) of the SQL Server Integration Services Projects – version 3.4 – extension for Visual Studio 2019. If you have not SSIS in Visual Studio 2019, it’s… different. Enjoy! :{>
Honored to Present Azure DevOps and the SSIS Development Lifecycle at Hampton Roads SQL Server User Group 15 Jan 2020!
I am honored to present Azure DevOps and the SSIS Development Lifecycle at Hampton Roads SQL Server User Group 15 Jan 2020! The primary goal of this session is an explanation – via demonstration – of the production release of an SSIS Project. We will walk this project through lifecycle management using Azure DevOps – …
Continue reading Honored to Present Azure DevOps and the SSIS Development Lifecycle at Hampton Roads SQL Server User Group 15 Jan 2020!
In 2020, Two Full Training Days, Two Continents
It dawned on me that I am honored to deliver two full-day conference training presentations in early 2020 on two continents! At the Difinity 2020 conference in Auckland New Zealand, Sandy Winarko and I are co-presenting Intelligent Data Integration with SSIS and Azure Data Factory 20 Feb 2020. Sandy is Principal Program Manager – Azure …
Continue reading In 2020, Two Full Training Days, Two Continents
Honored to Present From Zero to ADF at SQLBits 2020 in London!
Honored to Present From Zero to ADF at SQLBits 2020 in London 1 Apr 2020! When I look at this list of SQLBits Training Day presenters, I think, “Wow! That’s a lot of really smart people… plus me!” Registration is open now. Register today! :{>