How do I pass a variable to use as the ODBC Source SQL Command for Teradata in SSIS?

Question

I need to build a SELECT statement during the execution of an SSIS package to be used as the SQL command in an SSIS ODBC Source activity for a Teradata source.

The SELECT statement is built correctly, and all I need to do is assign it as the SQL command for the ODBC Source activity. I'm not looking to pass a variable as an argument to a query but to provide the entire SQL Command from a variable value.

Hadi · Accepted Answer · 2022-02-22 23:15:37Z

1

First of all, you should open the ODBC Source component editor and set the data access mode to SQL Command.

Next, you should select the Data FLow Task and press F4 to show the properties tab. Then, go to the expression property and open the expression editor dialog.

You will note that there is a property called ODBC Source.SQL Command that you can evaluate as an expression.

You can use the variable when evaluating this property as an expression.

answered Feb 22, 2022 at 23:15

Hadi

37.5k13 gold badges73 silver badges128 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Hadi Over a year ago

@JoeFoster If this answer solved the issue feel free to accept it

Collectives™ on Stack Overflow

How do I pass a variable to use as the ODBC Source SQL Command for Teradata in SSIS?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related