Use Variable in SQL Command SSIS of ADO net source

Question

I am using Visual Studio 2019 Community edition. I was trying to configure and ADO Net Source using SQL Command. However, I need to pass parameters to it. Is there an easy way to inject SSIS Variables into it?

Answer 1

Yes, you can do it, using expression. Open data flow task, right-click on empty space there and choose "Properties".

In "Properties" window choose "Expressions"

In opened window choose [Your data source].[SqlCommand] and add you variable there in Expression input.