question

ewinkiser avatar image
0 Votes"
ewinkiser asked ewinkiser commented

ADF COPY Activity Update Question

Hello! @nasreen-akter @KranthiPakala-MSFT @MartinJaffer-MSFT

I have a database table where the last column needs updating per the employeeid. Is there any way to do this in the COPY Activity or is a Stored Proc the only way to do this?

Thanks!
Mike Kiser

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

Hey,
Can you be clear on your architecture?
What is the source and sink in your copy activity?
And also how is the last column updated based on employee id? Is it based on some other table or is it a some case of substring like functions etc

0 Votes 0 ·

Thanks, @NandanHegde-7720 ,

Sorry for not being clear; the Source is a REST Source, the Sink is a SQL On Prem DB Table; the table is filled in by another pipeline so all I have to do is UPDATE the last column which is email address using the Employeeid. I can do it with a Stored Proc but would rather do it in a Copy Activity for maintenance reasons.

Thanks!!
Mike Kiser

0 Votes 0 ·

0 Answers