Use variable data source SSIS data flow

Navigation
1

In SSIS, I have a variable that takes the value of a query defined in a component "Execute SQL Task". The value of the variable is assigned correctly. What I want to do next is within a "Data Flow", using an "ADO origin", where the query is defined using the variable used previously in where .

How can I do it? I've searched everywhere and I can not find any of this.

I've tried something like 

SELECT col1,col2... 
  FROM tabla 
 WHERE col1 = @nombreVar.
    
asked by FormedMaca 29.09.2016 в 09:34
source

1 answer

1

In the data source ( Source ), choose data access mode SQL Command and where you specify that you are going to use a parameter using a question mark ? 

Select col1, col2, col3
from tabla
where col1 =?

Then you click on the button Parameters and there you choose the variable (User::NombreDeVariable) and leave input as the address

    
answered by 07.11.2016 в 19:32
problems with array in apps script Create document with data that can be filled in from Java