Execute SQL Task Editor

Question

There are 2 Option to use dynamic query in Execute SQL Task, Parameter Mapping and Expression.

Variable - where you create query on a variable e.g "Select * from" +@User::TableName Expression - where you create query direct to expression, same sample above.

Questions is which of the 2 is mostly used or better to use since this 2 have the same output?

Execute SQL task, component in SSIS.

Rommel20
– Rommel20

2014-02-25 04:00:33 +00:00
Commented Feb 25, 2014 at 4:00 — Rommel20
– Rommel20, Commented Feb 25, 2014 at 4:00

Rahul Tripathi · Accepted Answer · 2014-02-25 04:07:02Z

1

You can use the Execute SQL Task for your case using variable or expression. There is nothing like which is better. It all depends on your requirement. Both of the options have its pros and cons, so it is hard to predict which is better in your case without knowing your requirement.

You may check

edited Feb 25, 2014 at 4:07

answered Feb 25, 2014 at 4:01

Rahul Tripathi

173k33 gold badges292 silver badges341 bronze badges

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

Collectives™ on Stack Overflow

Execute SQL Task Editor

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related