First, please do not misunderstand. You should back up SSISDB just like you back up all other databases – especially in Production. You should also conduct Disaster Recovery exercises in which you restore SSISDB from the latest backup, or avail yourself of Always On availability groups and / or Windows Server Failover Clustering. To demonstrate …
Continue reading One Reason to Avoid SSISDB Backup and Restore
Category:SSIS
Azure-SSIS Catalog Database Connection Failed
I was provisioning a new Azure Data Factory (ADF) Azure-SSIS Integration Runtime (IR) to conduct some testing and, when I clicked the “Test connection” link, I got a Connection failed error as shown in the red box: I clicked the “More” link to display details in the blue box To provision new Integration Runtime, Azure …
Continue reading Azure-SSIS Catalog Database Connection Failed
Azure Data Factory and SSIS Training 2020-Q4
Join me 16-19 Nov 2020 for four days of SQL Server Integration Services (SSIS) training! Days 1 and 2 focus on development using real-world data (I love AdventureWorks for demos, but real-world data is never that clean). Students complete 10 labs on days 1 and 2 and get to play the game What Will SSIS …
Continue reading Azure Data Factory and SSIS Training 2020-Q4
SSIS 2019 Extension v3.10 for Visual Studio 2019 Released
The Microsoft Azure-SSIS team released version 3.10 of the SQL Server Integration Services Projects extension a couple weeks back. I missed it until today because my writing is keeping me in my SSIS 2017 VMs and, truth be told, I am a little off my game the past few weeks. Apologies for this delayed post. …
Continue reading SSIS 2019 Extension v3.10 for Visual Studio 2019 Released
How to Promote SSIS Code in the Enterprise Lifecycle
I’ve written about Data Integration Lifecycle Management (DILM) tiers. To summarize, every enterprise needs at least four lifecycle management tiers: 1. Development – an environment in which developers have sysadmin privileges. 2. Test – another environment in which developers have sysadmin privileges. 4. Production – managed by production operations such as domain administrators, system administrators, …
Continue reading How to Promote SSIS Code in the Enterprise Lifecycle
Where’s the SSIS Dropdown Menu in Visual Studio 2019?
Just the other day, I was whining to communicating with friends on the Microsoft SSIS team about the SSIS dropdown menu in Visual Studio 2019, sharing “The SSIS dropdown menu is missing.” In Visual Studio 2017 (SQL Server Data Tools), the SSIS dropdown menu is prominently displayed alongside other top-level dropdown menu items: The SSIS …
Continue reading Where’s the SSIS Dropdown Menu in Visual Studio 2019?
How to Skip SSIS Package Validation
A new feature in version 3.9 of the Visual Studio 2019 SSIS extension is “skip package validation.” I’ve tested the functionality and it works well. Here’s how you set it up: First, install the Visual Studio 2019 SSIS version 3.9 extension. Next, open Visual Studio 2019 and click Tools > Options: Navigate to Business Intelligence …
Continue reading How to Skip SSIS Package Validation
Integration Services Extension v3.9 is Available
Integration Services Extension v3.9 is now available for Visual Studio 2019. I tested the skip-package-validation feature and I like it! Interesting (to me) is skipping deployment to Azure-SSIS for all target server version except SSIS 2017. Release Notes: Version 3.9 (Current Version): Release Date: August 24th, 2020 Build Version: 15.0.2000.128 Tested against Visual Studio 2019 16.7 …
Continue reading Integration Services Extension v3.9 is Available
Azure DevOps and the SSIS Development Lifecycle on LinkedIn Live
I was honored to deliver Azure DevOps and the SSIS Development Lifecycle at 12:00 PM EDT 18 Aug 2020. This is a condensed version of a larger presentation that goes by the same name. This version lasted about 20 minutes and is packed with information about basic build automation using Azure Pipelines with SSIS. I …
Continue reading Azure DevOps and the SSIS Development Lifecycle on LinkedIn Live
Free! Azure DevOps and the SSIS Development Lifecycle Presentation
I’m excited to deliver Azure DevOps and the SSIS Development Lifecycle at 12:00 PM EDT Tuesday, 18 Aug 2020! This time, though, I am trying something new – LinkedIn Live! That means there’s no registration and no sign-up. Just show up at LinkedIn and attend. I’m not sure if you need to be following me on …
Continue reading Free! Azure DevOps and the SSIS Development Lifecycle Presentation