question

balaa-uk avatar image
0 Votes"
balaa-uk asked SaurabhSharma-msft edited

How to add one day to Source Column and write to sink

I have a Copy activity that has Source and Sink pointing to same data source (CRM).

Source has a column date1 to which I want add a day and write it to date2 in Sink.

How can it be achieved or How do I reference the Source column name in Dynamic expression?

azure-data-factory
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

SaurabhSharma-msft avatar image
0 Votes"
SaurabhSharma-msft answered SaurabhSharma-msft edited

Hi @balaa-uk,

Thanks for using Microsoft Q&A !!
No, it is not possible to use the source column values in dynamic expression while adding an additional column in copy data activity. If your source is SQL then you can use Stored Procedure or SQL Query in source to add a new column and target it to the sink tables. In your case as the source is different, you could try to use Dataflow to achieve the same.
Please let me know if you have any additional questions.

Thanks
Saurabh

· 5
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

It's very funny, Dataflow doesn't support CRM/Dynamics etc.

0 Votes 0 ·

@balaa-uk, sorry my apologies. I missed that CRM is not supported in Dataflow. Can you please let me know what's the sink is ? is it SQL ?

0 Votes 0 ·

@balaa-uk,

Did you get a chance to look into my previous ask so that I can help you.

Thanks
Saurabh

0 Votes 0 ·
Show more comments