error while executing

Question

Hi All,

When i am executing this task throgh SSIS

[Execute SQL Task] Error: Executing the query "EXEC ?   = dbo.sp_dw_audit_add ?,?,?,?,?,?,?,?,?,? " failed with the following error: "No value given for one or more required parameters.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. 

Answer 1

following error: "No value given for one or more required parameters.".  

As the error message says, you have to assign for all parameters = ? in your query a value.

---

Olaf Helper

Blog Xing

Answer 2

Hi,

Try my blog for an example on Parameter Mapping inside Execute SQL Task in SSIS - http://sathyadb.blogspot.in/2013/04/ssis-execute-sql-task-result-set-and.html

For number of ? mentioned in the query you should do parameter mapping with corresponding variables.

Here are somemore reference links :

http://blogs.msdn.com/b/msdnts/archive/2006/11/17/amazing-ssis-parameters-in-execute-sql-task.aspx

http://technet.microsoft.com/en-us/library/ms140355.aspx

http://www.sqlis.com/sqlis/post/The-Execute-SQL-Task.aspx

---

sathya --------- Please Mark as answered if my post solved your problem and Vote as helpful if my post was useful.