asked on

How to push the filtered data into data flow task in SSIS?

I need to push the filtered data into data flow task... In the control flow task I have 2 'execute SQL task' and one Data flow task connected one after the other. HOW can I use the output result set of the Execute sql taks into the data flow ? The two 'execute sql task' performs filter operations and is running fine while debugging.

Inside the datflow task I use a source OLEDB ? What shall I use as a source to get the filtered output data from SQL task in Control Flow...

Gowtham Ramamoorthy

ASKER

I need to get the recent data into the data flow task.. How could this be achieved... I not sure whether if we connect the sql task with the data flow will implicitly allow the filtered data into the data flow,, can someone guide me on this please...

Vikas Garg

Hi,

I think you can write the same query which you wrote in the Execute SQL task to the Data source of the Data Flow Task.

Gowtham Ramamoorthy

ASKER

But I use a variable in that SQL task in control flow?? when i tried with the same query its throwing the error...?

Vikas Garg

You can also use a variable in Oledb source.

What error are you getting ?

Can you share the screenshot ?

Gowtham Ramamoorthy

ASKER

Attached Screenshot
ErrorScreenShot.png

Gowtham Ramamoorthy

ASKER

I tried not using (User::) but again an error occurs stating 'Invalid Column name'

ASKER CERTIFIED SOLUTION

Vikas Garg

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Gowtham Ramamoorthy

ASKER

Awesome got worked..Thanks a lot Vikas....