Choosing Between SQL Server Integration Services and Azure Data Factory
In this article we look at the similarities and differences of SSIS and Azure Data Factory and provide some insight as to when you would use one over the other.
2022-01-21
Azure Data Factory
Working with an Azure Data Factory Meta-data Driven Pipeline
This article shows how to create a data driven ADF pipeline.
2021-11-22
4,549 reads
How to Recover a Corrupted Azure Data Factory Integration Runtime
I would like to share my recent experience with Azure Data Factory (ADF) where AutoResolveIntegrationRuntime become corrupted and how did I recover it. I still don't know how the Integration Runtime (IR) was corrupted. However, if it happens, then this article will help you to solve the issue. Problem In general, the ADF AutoResolveIntegrationRuntime should […]
2021-11-05
1,561 reads
Azure Data Factory Incremental Pipeline from Azure SQL Database to Databricks
In this tip find out how to use Azure Data factory to build an incremental pipeline from Azure SQL Database to Databricks.
2021-08-25
Working with Get Metadata Activity in Azure Data Factory
Learn how to gather metadata information about the files being processed in your ADF pipeline.
2021-08-20
13,001 reads
Upsert Operation in Cosmos DB using Azure Data Factory
This article covers the basics of upserting data in CosmosDB using Azure Data Factory.
2021-07-23
8,986 reads
Handling Row-level Errors in ADF Data Flows
If you are working with ADF (Azure Data Factory) data flows, then you may have noticed there was a new feature released in November 2020, which is useful to capture any error while inserting/updating the records in a SQL database. This article will describe how to setup the error row handling feature and why it's […]
2021-06-16 (first published: 2021-05-02)
3,217 reads
Dynamically Add a Timestamp To Files in Azure Data Factory
This article will describe how to add your local timestamp at the end of the each file in Azure Data Factory (ADF). In general, ADF gets a UTC timestamp, so we need to convert the timestamp from UTC to EST, since our local time zone is EST. For example, if the input Source file name […]
2021-04-22
17,652 reads
Reading Stored Procedure Output Parameters in Azure Data Factory
This article will help you to work with Store Procedure with output parameters in Azure data factory.
2021-04-06
19,008 reads
Migrating SSIS packages to Azure - Lift and Shift using Azure Data Factory
Unlike an on premises SQL Server, Integration Services (SSIS) works very differently on Azure. If there are requirements to run our existing SSIS packages on Azure, then we need to understand our options. In this article we will talk about our options for migrating SSIS to Azure and what components are required to migrate SSIS packages. […]
2021-04-05 (first published: 2021-03-22)
6,349 reads
Blogs
What Do I Do to Relax?
By Steve Jones
I’ve republished an editorial today from another author, called What do you do to...
Daily Coping 9 Dec 2022
By Steve Jones
Today’s coping tip is to find out something new about someone you care about....
Advent of Code 2022
By Zikato
Foreword Advent of Code is an annual event in which participants solve a series of...
Forums
SSRS - Add end date for all SSRS subscriptions
Hi, Could you please advice if it is possible to add an end date...
blank page
Hi guys! The topic "Connect to SQL Server with Python to Create Tables, Insert...
Ask SSC