Hi
I have a flow variable, lets call it A, which is a table consisting of 1 column and multiple rows.
Then i am opening an SQL connection, where i try to create a table in my SQL Server which has the content of variable A.
However, i am not able to refer to a Flow variable inside the SQL statement.
I was able to refer to a single value from variable A if i first used the following:
DECLARE @SQLVariable varchar(20)
set @SQLVariable@= %A%
insert into [Database].[schema].[table]
select @SQLVariable
However, whenever A exceeds a single value i get an error.
Do you have any suggestions on how i can load the flow variable %A% into the SQL instance, and create the table in my SQL database, based on my flow variable with multiple values?
Thanks in advance!
