Using Delimiters with HashBytes for Change Detection

A week or so back, I streamed 100% Efficient Data Integration, which you can view below (from LinkedIn) or by clicking the link to the YouTube recording: I share this SSIS Design Pattern in my Expert SSIS course. I next deliver Expert SSIS 14-15 Dec 2020. Also, Expert SSIS is on sale for 50% off …
Continue reading Using Delimiters with HashBytes for Change Detection

AWS and SSIS

Brent Ozar, my friend and brother from another mother, shared an interesting link on LinkedIn. The article Brent linked is titled Amazon RDS for SQL Server now supports the Business Intelligence Suite on SQL Server 2019. I find the topic interesting for a number of reasons. I’m interested in helping enterprises lift and shift on-premises …
Continue reading AWS and SSIS

Global Parameters in SSIS Framework

I’m happy to announce the latest version of our SSIS Framework includes global parameters! I can hear some of you thinking, … “What Are Global Parameters, Andy?” I’m so glad you asked! SSIS ships with package-scoped and project-scoped parameters. Project-scoped parameters may be used in any SSIS package in the project; package-scoped parameters are only …
Continue reading Global Parameters in SSIS Framework

Executing Synchronously from DtExec

Five years ago, I wrote a blog post titled The SYNCHRONIZED SSIS Execution Parameter. Recently, I received a comment with a question: One way to execute SSIS packages stored in the SSIS Catalog from SQL Agent is to use the CmdExec job step type. As with all command-level access, please research security implications. Use a …
Continue reading Executing Synchronously from DtExec

Environment Properties Node for Catalog Browser

I’ve been working on SSIS Catalog Compare and its free counterpart┬áSSIS Catalog Browser. Earlier I added Folder and Project Properties nodes, more recently I added Environment Properties: Environments are… tricksy. Why? Because of broken references. I can hear some of you thinking,… “What’s a broken reference, Andy?” That’s an excellent question – I’m glad you …
Continue reading Environment Properties Node for Catalog Browser

Folder and Project Properties Nodes for Catalog Browser

I’m happy to announce the addition of Folder Properties and Project Properties nodes to SSIS Catalog Browser, a free utility from DILM Suite that surfaces a unified view of the SSIS Catalog: As ever, the same functionality is available in SSIS Catalog Compare. Contact Enterprise Data & Analytics to learn more. Enjoy! :{> Need Help? …
Continue reading Folder and Project Properties Nodes for Catalog Browser

My Black Friday 2020 Sale is On!

Do you read my blog? Would you like to save money on Azure Data Factory and SSIS training (from me!) for a full year? For a limited time, you can save $4,000 (67%) on my Live ADF and SSIS Class Season Pass! Visit Enterprise Data & Analytics Training to view upcoming public course deliveries and …
Continue reading My Black Friday 2020 Sale is On!

One Reason to Avoid SSISDB Backup and Restore

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

Buy the Live Season Pass 01-14 Nov and Save

It’s that time of year again: Enterprise Data & Analytics kicks off the Black Friday Training Sale 13 Nov 2020 with a substantial discount – for two weeks only, 01-14 Nov 2020 – on our Live Season Pass. Sign up for the Live Season Pass and attend my SSIS and ADF training course deliveries for …
Continue reading Buy the Live Season Pass 01-14 Nov and Save