Parameter Order in SSIS SQL Task

Question

I’m passing 2 parameters into a SQL Task in SSIS as follows ... 

UPDATE dbo.MyTable 

SET RunDate=GetDate(), 

RunDuration=datediff(second, ?, GetDate()) 

WHERE CourseTitle=? 

  

What I want to do (but can’t find a way to) is pass 3 parameters like this... 

UPDATE dbo.MyTable 

SET RunDate=Param2 

RunDuration=datediff(second, Param1, Param2) 

WHERE CourseTitle =Param3 

 
Is this possible 

Thanks in advance  

Roy 

Answer 1

In Parameter mapping, you should be able to map these variables with sequence

From Execute SQL Task Editor:

For parameter Name: 0, 1, 2, 3 respectively to map your parameters. 0 and 2 are the same to map to Param2.

UPDATE dbo.MyTable

SET RunDate=? RunDuration=datediff(second, ?, ?)

WHERE CourseTitle =?

Check out this discussion:

https://stackoverflow.com/questions/7610491/how-to-pass-variable-as-a-parameter-in-execute-sql-task-ssis

Answer 2

Hi @RoyB09

If you are using OLE DB connection, the Parameter marker should be ? and the Parameter name should be 0, 1, 2, 3, ...

Check it out here: Execute SQL Task

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Answer 3

What I want to do (but can’t find a way to) is pass 3 parameters like this...

Sure it's possible; you didn't mentioned what exactly the problem is?

Depending on the data source (which you also didn't mentioned) you have to use the question mark ? as placeholder for a parameter on you can use named parameters like @ parameterName.