How to pass variable to sql query of ODBC Source in SSIS?

Question

I am using ODBC source in Data flow task of SSIS. I want to select only latest data from ODBC source,

Here is my query:

Select * from ODBCTable where date >= @[user::date1]

But i am getting error while parsing query.

What is the alternative way this? How can i pass the variable and how to create effective variable to pass the query that can give me only latest today's date data.

I have defined variable but how can i use ? insted of @[user::date1], how to map these. — Jack, Dec 30 '15 at 11:35
where you define the variable there is one mapping tab within that map the variable and with your where clause variable and put question mark after equal sign — wiretext, Dec 30 '15 at 11:41
Possible duplicate of [SSIS ODBC SQL parameters](http://stackoverflow.com/questions/26762110/ssis-odbc-sql-parameters) — Tab Alleman, Dec 30 '15 at 14:19

score 2 · Answer 1 · edited Sep 28 '16 at 18:02

2

You can do in this way create one variable query then form your query there with parameter . enter image description here

enter image description here

then goto dataflow properties , in expression select ODBC source.sqlcoomand and pass that variable here.

On first run will replace source query with the expression sql command. Thanks

edited Sep 28 '16 at 18:02

gofr1

15,741
11
42
52

answered Sep 28 '16 at 17:43

Aashish Jain

121
5

score 2 · Accepted Answer · answered Sep 28 '16 at 17:51

In the SQL Command text, first declare your variable then write your sql statement:

declare @user_date1 date = cast(? as date)

Select * from ODBCTable where date >= @user_date1

Then click on the Parameters button to map an SSIS parameter value to your sql variable. The mapping is done in order of appearance in your SQL Command - not by name.

How to pass variable to sql query of ODBC Source in SSIS?

2 Answers2

Linked