column display current date

Question

Hello team,

I want to copy the data from sql server table to synapse sql pool via dynamic query.

Source Destination Values
column 1 column1 ABC
column2 column2 123
column3 column3 BANGALORE
column4 column4 SYSDATE

For column 4 i need to display the sysdate on the fly. How it can be achieved .Please advise.

Reards
RK

Answer 1

Hey ,
Below are the ways to achieve it:

1. In the source itself update your query as
   Select column1,column2,column3,getdate() as column3

2) https://learn.microsoft.com/en-us/answers/questions/318521/how-do-i-pass-a-static-value-as-source-column-in-c.html
wherein add additional columns with static values in copy activity.
You can use utcnow() function