I cannot assign return of the expression in the SSIS variable

Asked

Viewed 262 times

-1

Task to insert Variable Value by select result

Task para fazer o update no campo valor usando como values o valor da variável

Select que insere os valores na variável update Update na tabela STG_Vendas usando o valor da variávelPropriedades da variável

My intention with this logic is to pass a column calculated from one excel file to another using an area of Stage where I just want to modify a column in the database table and then insert inside the excel file. That’s why I’m using variable to take the result of select and use as value in update, because there is more than one connection. But the value of the variable does not change when I run a taskConjunto de valores da taskParametros da task

visual-studio-2015 ssis business-intelligence

1 answer

0

The variable you are using for mapping is not the same as the one leaving the Result Set. By the way, when you use a variable that is mapped, you do not need to put its name, just put in the query a question mark (?) that it will use the variables mapped based on their mapping name (0,1,2,3).

  • Could you give me an example of query ?

  • In your Update: Update Stg_sales Set Vlr_purchase = ? Where Codigo_product is not null

Browser other questions tagged visual-studio-2015 ssis business-intelligence

You are not signed in. Login or sign up in order to post.