Azure Blob to Azure SQL Database - Data Factory

Question

I have a CSV file which contains Name and DOB of persons. I want to store it in Azure SQL database with an additional column of Age which has to be calculated using current date and DOB (from CSV file). Please suggest how to find age in a pipeline activity from this file and store in database. Thanks

DateTime.Now - DoB... or if your are using TSQL getdate() - DoB .... something like that — Thomas
– Thomas, Commented Jun 2, 2016 at 11:33
But where to specify this calculation in my data factory pipeline? — seou1
– seou1, Commented Jun 2, 2016 at 11:44
I am using a copy activity in data factory. But obviously in this case, the Age column is being null as blob contains only name and DOB. So I need to find Age and put it along with other data from blob in database. — seou1
– seou1, Commented Jun 2, 2016 at 11:57

Harish Agarwal · Accepted Answer · 2016-06-02 16:56:04Z

2

One of the simplest ways to go about doing this is by invoking a stored procedure on the destination (Azure SQL DB) from within the copy activity. You can pass the ADF system variable 'WindowStart' as a parameter to the stored procedure and within the stored procedure the age calculation can be done. This link (https://azure.microsoft.com/en-us/documentation/articles/data-factory-azure-sql-connector/#invoking-stored-procedure-for-sql-sink) would help.

Thanks, Harish

answered Jun 2, 2016 at 16:56

Harish Agarwal

361 bronze badge

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Azure Blob to Azure SQL Database - Data Factory

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related