question

95039590 avatar image
0 Votes"
95039590 asked SaurabhSharma-msft edited

Azure Data Factory Copy Activity dynamic data transformation for string columns (TYPE CONVERSION for char columns)

Hi ,

I am using a Copy activity to dynamically copy several sources from SQL source to SQL target.

How ever i want to convert automatically all character data type columns using transformation "UPPER"

I can not see any option for applying transformation's to string columns under TYPE CONVERSION

is there any way around to implement this data transformation automatically ?

Thanks

azure-data-factory
· 3
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.

@95039590 Thanks for using Microsoft Q&A !!

You need to use Data Flow activity to convert incoming character column datatype values to UPPER values. This cannot be done using Copy Activity as per my understanding of your ask. You could refer to Data Flow activity in Azure Data Factory on using data flows.

Please let me know if you have any other questions.


0 Votes 0 ·

@95039590 Please let me know if you have any other questions.

0 Votes 0 ·

Hi @95039590,
I am following up as I haven't heard back from you.

Thanks
Saurabh

0 Votes 0 ·

0 Answers