How to use variable in select statement?

Question

I'm trying to use the logic for using SSIS

select top 2 * from table

How can I replace 2 with variable name and make it customize?

Update

I tried using expression and i received the following error:

@IsaacVidrine the question is not SSIS related, how it can be a duplicate — Hadi
– Hadi, Commented Apr 25, 2019 at 19:43

Hadi · Accepted Answer · 2019-04-25 19:42:36Z

3

Assuming that the variable that contains the number of top rows is named @[User::TopCount]

Create a variable of type string (example: @[User::strQuery]), set its property EvaluateAsExpression to True. And assign the following expression:

"SELECT TOP " + (DT_WSTR,10)@[User::TopCount] + " * FROM table"

Inside the data flow task add an OLEDB Source and set the Access mode to SQL Command from variable and use @[User:strQuery variable as source.

answered Apr 25, 2019 at 19:42

Hadi

37.5k13 gold badges73 silver badges128 bronze badges

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

2 Comments

Hadi Over a year ago

@TirathSingh can you provide the expression used?

Hadi Over a year ago

@TirathSingh check the following link: mssqltips.com/sqlservertip/4564/… follow the SSIS Expression for Variables section

Chris Steele · Accepted Answer · 2019-04-25 20:59:41Z

2

declare @numrows int = 5

select top (@numrows) * from MyTable

answered Apr 25, 2019 at 20:59

Chris Steele

1,3811 gold badge9 silver badges21 bronze badges

Collectives™ on Stack Overflow

How to use variable in select statement?

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related