When you work with ETL and the source file is JSON, many documents may get nested attributes in the JSON file. Your requirements will often dictate that you flatten those nested attributes. There are many ways you can flatten the JSON hierarchy, however; I am going to share my experiences with Azure Data Factory (ADF) […]
2021-09-17
3,130 reads
Learn how to gather metadata information about the files being processed in your ADF pipeline.
2021-08-20
2,943 reads
There is a Power Query activity in SSIS and Azure Data Factory, which can be more useful than other tasks in some situations.
2021-07-26
2,936 reads
This article will help you to work with Store Procedure with output parameters in Azure data factory.
2021-04-06
8,426 reads
This post will describe how you use a CASE statement in Azure Data Factory (ADF). If you are coming from SSIS background, you know a piece of SQL statement will do the task. However let's see how do it in SSIS and the very same thing can be achieved in ADF. Problem statement For my […]
2020-11-12
7,356 reads
By kleegeek
Join us on December 8th at 10am Pacific time for an exciting new webinar!...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Hi Everyone For some reason, all the values I imported into SS got changed...
Comments posted to this topic are about the item Holiday Fun for Your Career
Comments posted to this topic are about the item Get backup folder sizes from...
Ask SSC