How to move Table varaible to Azure Data warehouse using Azure Data Factory

Question

We have a table name "@tablename" in SQL Server 2016. Using ADF, we are moving data from SQL Server to Azure DW but it throws a error - ErrorCode=InvalidTemplate, ErrorMessage=Unable to parse expression 'tablename': expected token 'LeftParenthesis' and actual 'EndOfData'."

Is there any way to move table variable through ADF?

Answer 1

There must be some code which is filling data in Table variable. You can try providing that select query in Copy activity source and load data to target.

---

Please don't forget to Accept Answer and Up-vote if the response helped -- Vaibhav

Answer 2

Hello @Sarvesh Pandey ,
I tried the below query and it just wroked fine . There is something else which is wrong in our case .

DECLARE @rayn _TABLEVARIABLE TABLE
(Name varchar(100)
)
INSERT INTO @rayn _TABLEVARIABLE values('Jon doe')
SELECT Name from @rayn _TABLEVARIABLE