ETL

SQLServerCentral Article

Dynamically Add a Timestamp To Files in Azure Data Factory

  • Article

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

5 (2)

2021-04-22

7,346 reads

SQLServerCentral Article

Modular ETL Architecture Design in SSIS

  • Article

Overview of ETL Architecture In a data warehouse, one of the main parts of the entire system is the ETL process. ETL is the system that reads data from the source system, transforms the data according to the business logic, and finally loads it into the warehouse. While fetching data from the sources can seem […]

4 (2)

2019-10-21

13,048 reads

Blogs

Be careful with table updates

By

The dire warning in the subject line is not meant to scare you. Rather,...

Daily Coping 1 Dec 2021

By

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

Building a pacemaker cluster to deploy a SQL Server availability group in Azure

By

There are new Ubuntu Pro 20.04 images available in the Azure marketplace with SQL...

Read the latest Blogs

Forums

Führerschein kaufen in Belgien WhatsApp... +49 1521 0248216)) MPU Berlin

By mariagiorgis31

Deutschen Führerschein ohne MPU in EU und UK nach dem Brexit - EU Führerschein...

Get Full Name and Last Name in Report

By rafamaniac

Hello, i have tried multiple expressions from websites and couldn't get the real answer....

Help with Column Visibility Expressions

By Jeffs1977

I have a parameter in my report labeled as PaySource. PaySource has 3 values...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers