Using System/User Variables as Parameters in an OLE DB Source Query

Question

I have got a SQL command like the following :

SELECT *
FROM temp1 a
inner join (SELECT ID from temp2 where ID = ?) b on a.ID = b.ID
WHERE a.ID = ?

I know the query has incorrect logic. But my question is How will I set Variables as parameters here in the place of "?". If I exclude the joined part, it will work.

bobs · Accepted Answer · 2010-11-14 17:42:16Z

1

Edit the OLE DB Source. On the Connections Manager tab, click the Parameters... button. The Parameters dialog will display the parameters in the sequence they appear in the SQL statement. The sequence is determined by reading the SQL statement from left-to-right, top-to-bottom.

To make an assignment to a parameter, select the variable from the Variables column.

answered Nov 14, 2010 at 17:42

bobs

22.3k12 gold badges71 silver badges81 bronze badges

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

1 Comment

Sreejesh Kumar Over a year ago

Thanks...I already got the solution. I tried for Expression Builder since I have to map parameter in Sub Querys.

Collectives™ on Stack Overflow

Using System/User Variables as Parameters in an OLE DB Source Query

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