parameter size in execute sql task is not working

hello,

i executing stroc proc using execute sql task . passing 2  parameters follows

connection: ole db

sqlstatement  :   exec sp_updatereportlog ?,6

bypassprepare : true

 

the parameter mapping is follows:

variablename      direction      datatype        paramname  paramsize

user::sourcefile  input          nvarchar       0               -1

when execute task recieved following error.

error: string or binary data truncated. [execute sql task] error: executing query "exec [dbo].sp_updatereportlog ?, ?, 6 " failed following error: "the statement has been terminated.". possible failure reasons: problems query, "resultset" property not set correctly, parameters not set correctly, or connection not established correctly.

the variable user::sourcefile size has value of 110 char lenght, combined path + filename. did regression testing truncating file name 1 until executed sucessfully @ 100.  seems default parameter size of -1 can handle 100 char size. i went ahead , change 256 thinking solved problem didn't.  

note: work around, have reduce file name size not option. file name contains rules important in our processing , received third party.

i using sql 2005 sp3. advise appreciated.

thanks,

sqlbibabe

error: string or binary data truncated. [execute sql task] error: executing query "exec [dbo].sp_updatereportlog ?, ?, 6 " failed following error: 

though saying passing 2 parameters error message says there 3 (?,?,6). have not mapped 2nd parameter. also know result set , setup that.

SQL Server  >  SQL Server Integration Services