Erorr in Parameter mapping for execute SQL task

• subha V

  SSC-Addicted

  Points: 402

  More actions

  November 2, 2012 at 1:38 am

  #264228

  Hi,

  my requirement is to call a same stored procedure 4 times inside a single execute SQL task in SSiS 2005.

  I have given the following inside enter SQL query

  EXECUTE dbo.usp_Tablename_Update

  @I_bitTablenameValue = ?,

  @I_intTablenameId = 1

  EXECUTE dbo.usp_Tablename_Update

  @I_bitTablenameValue = ?,

  @I_intTablenameId = 2

  EXECUTE dbo.usp_Tablename_Update

  @I_bitTablenameValue = ?,

  @I_intTablenameId = 3

  EXECUTE dbo.usp_Tablename_Update

  @I_bitTablenameValue = ?,

  @I_intTablenameId = 4

  Paramater Mapping:

  Variable Name : Direction : Data Type: Parameter Name

  USer:value1 : Input :Variant_Bool :0

  USer:value2 : Input :Variant_Bool :1

  USer:value3 : Input :Variant_Bool :2

  USer:value4 : Input :Variant_Bool :3

  I got the following error : failed with the following error: "Invalid parameter number". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

  But it works fine if i have just 3 execute statement and parameter mapping till paramatername 3.

  Can anyone please help me..

• stelios21

  Valued Member

  Points: 74

  More actions

  March 17, 2017 at 8:07 am

  #1933743

  A bit late for you but I have found the answer here:

  http://milambda.blogspot.de/2014/02/sql-server-integration-services-data.html#ssisdtmdatetime

  very useful article for all sorts of data type mappings within SSIS