Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Use Variable in SQL Command SSIS of ADO net source

Tags:

ssis

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?

like image 200
Tom Avatar asked Oct 13 '25 01:10

Tom


1 Answers

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

In "Properties" window choose "Expressions" enter image description here

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

like image 183
Alex Sham Avatar answered Oct 16 '25 11:10

Alex Sham



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!