Dynamic input to t-sql task in SSIS

Question

I have a package that includes a T-SQL step. I have created som variables to use in the t-sql statement. But I don't find the correct syntax for using the variable in my t-sql statement.

My variable is QuarterID. And in my t-sql I want to use this variable.

t-sql: DECLARE @myQuarterId int select @myQuarterId = User::QuarterID

I have tried "@(User::QuarterID)", "@QuarterID", and all different syntax. Is there anyone out there who could help me on this one?

HLGEM · Accepted Answer · 2010-11-17 15:20:26Z

2

YOu open the Execute SQL task and got to the parameter mapping tab and add the variables inteh order you want to reference them. Make sure to change the parameter names to numbers starting with 0 for the first variable you use and incrementing by one for each other variable. Then go back to the general tab and write your query

DECLARE @myQuarterId int select @myQuarterId =?

answered Nov 17, 2010 at 15:20

HLGEM

97k15 gold badges120 silver badges191 bronze badges

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

Collectives™ on Stack Overflow

Dynamic input to t-sql task in SSIS

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