ADF

SQLServerCentral Article

How to Flatten JSON in Azure Data Factory?

  • Article

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) […]

4.5 (2)

2021-09-17

3,130 reads

SQLServerCentral Article

How to simulate Case statement in Azure Data Factory (ADF) compared with SSIS?

  • Article

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 […]

4.5 (2)

2020-11-12

7,356 reads

Blogs

Dec 8 Webinar with Pavilion – Boost SQL Server on VMware Performance 400% with 2-Step Tuning

By

Join us on December 8th at 10am Pacific time for an exciting new webinar!...

Daily Coping 3 Dec 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Daily Coping 2 Dec 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

Dates got changed to string when imported

By water490

Hi Everyone For some reason, all the values I imported into SS got changed...

Holiday Fun for Your Career

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Holiday Fun for Your Career

Get backup folder sizes from shared Location

By HBhagat

Comments posted to this topic are about the item Get backup folder sizes from...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers