Sorry but how do you set this in SSIS?

Ooppss... I forgot to declare the other two variables.

It is working now.

Thank you so so much!!!

I'm getting this error:

[Execute SQL Task] Error: Executing the query "exec AutoVer_Staging_DelqLoan @Trans_date = ?,@StoreNo = ?" failed with the following error: "Parameter name is unrecognized.". Possible failure reasons:...

Thanks. That was a quick one.

I'll try this out.

Sorry. I thought I can move it to SSIS topic.