ADF: Table type parameter in ADF copy activity source

Sridhar Boopalan 1

I'm want to move data form source DB to Target DB. I'm using series of copy activity to move the data form source to target. In copy activity in the source I'm calling stored procedure and what ever SP returns that I'll dump in target DB using sink. In that one of the SP in my source DB having user defined table type as input parameter. How to call this SP in the copy activity source with table type as a input parameter.

1 answer

Vinodh247 18,101 Reputation points

2022-07-27T09:03:23.387+00:00

Hi Sridhar,

Thanks for reaching out to Microsoft Q&A.

I see a similar requirement has been demonstrated and documented by 'Bob Rubocki' as a blog article. Link has been given below, please check if this would useful for you.

https://blog.pragmaticworks.com/using-stored-procedure-in-azure-data-factory

Please Upvote and Accept as answer if the reply was helpful.
Please sign in to rate this answer.

1 person found this answer helpful.
Sridhar Boopalan 1 Reputation point

2022-07-27T09:37:27.767+00:00

Hi Vinodh

Thanks for you response. Ill go through the article.

Vinodh247 18,101 Reputation points

2022-08-01T05:30:05.423+00:00

Just checking in to see if the below answer helped. Please do consider clicking Accept Answer and Up-Vote for the same as accepted answers help community as well.

Sridhar Boopalan 1 Reputation point

2022-08-01T05:56:28.993+00:00

Hi Vinodh,
Actually it's not helping me, the article explaining how to use table type in sink side, but I want to know how to use table type in source side.

Vinodh247 18,101 Reputation points

2022-08-01T06:42:45.613+00:00

Sorry, I missed to add another link to my answer that day.

Martin has solved this by using the Query option in source configuration instead of calling it as an stored proc. This solution should work for your issue.

https://stackoverflow.com/a/61013253

Please Upvote and Accept as answer if the reply was helpful.

Bhargava-MSFT 30,816 Reputation points Microsoft Employee

2022-08-04T20:16:29.42+00:00

Thank you @Vinodh247

Hi @Sridhar Boopalan ,
Please let us know if you have any further questions.

If this answers your query, do click Accept Answer and Up-Vote for the same so that it will be helpful to the other community members.

Bhargava-MSFT 30,816 Reputation points Microsoft Employee

2022-08-10T00:22:11.067+00:00

Hi @Sridhar Boopalan ,
Please let us know if you have any further questions.

Sridhar Boopalan 1 Reputation point

2023-03-20T16:51:55.4766667+00:00

Hi Vinodh,

Sorry for the late response. This is what i'm looking for, this worked for me. Thanks @Vinodh247

Bhargava-MSFT 30,816 Reputation points Microsoft Employee

2023-03-20T21:29:32.8266667+00:00

Hi @Sridhar Boopalan ,

Thanks for the confirmation.

Please click Accept Answer and Up-Vote for the same so that it will be helpful to the other community members.

Krishna Kumar Velayudham 0 Reputation points

2024-09-03T15:29:50.64+00:00

I have tried the example provide in the pragmatic works, does not work for me, there is something missing on how the source which is a csv file gets assigned to the parameter for the stored procedure which is a table type @Sridhar Boopalan did you get it to work ?
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

ADF: Table type parameter in ADF copy activity source

1 answer

Your answer