how can use variable in odbc source

Büşra Zencir 0 Reputation points


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?

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,451 questions
0 comments No comments
{count} votes

3 answers

Sort by: Most helpful
  1. ZoeHui-MSFT 32,506 Reputation points

    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.


    Zoe Hui

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

    0 comments No comments

  2. Büşra Zencir 0 Reputation points


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


    My sql task:resim



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


    0 comments No comments

  3. Olaf Helper 40,656 Reputation points

    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 ..