how can use variable in odbc source

Question

hello,

i want to set variable from execute sql task and using this variable odbc source in data flow task. How can doing this? I set variable but when i running package gets variable empty error.

Can you help me?

Answer 1

Hi @Büşra Zencir,

How do you set the execute sql task?

Here is a tutorial about assigning value to a variable in the task, you may check to see if you have miss any steps.

https://insightextractor.com/2014/07/08/ssis-how-to-use-execute-sql-task-to-assign-value-to-a-variable/

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Answer 2

Hi,

Thank you so much bu it doesnt work. I did same things this link but i get error.

My sql task:

İ get this error: (data flow task exists one odbc source, sql command)

Answer 3

I see a

select count(*) from ..

You have to use a column alias for the result, otherwise SSIS can't address it =>

select count(*) AS Cnt from ..