November 2, 2012 at 1:38 am
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..
March 17, 2017 at 8:07 am
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
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply