calling stored proceduer that expect an input parameter

Greetings,

Got an error when using stored procedure in the transformation. This issue could be that this stored procedure has input parameter but it can accept null value. Please see screen shot. This error is under the reader function right after I define the stored procedure.
Please advise.

Thank you.

Please post reader screenshots

Mike

here is the reader screen shot as you requested.
I wish the reader can accept input under transformation .. i.e .. can accept input from another function within the transformation.

1) here is the reader screen shot as you requested.
I wish the reader can accept input under transformation .. i.e .. can accept input from another function within the transformation.

It can accept it using variables

2) so why you are not passing parameter within the reader?

Mike

i am just figuring out and eliminating the issue. because on my other transformation, i can call the stored procedure by the reader without any issue.
Now i figured out the issue. the issue is this stored procedure when i execute, it does the update internally as well. The etl reader caused this error when calling a stored procedure the do update and select inside. This stored procedure do two things, if i pass 0 it will give me a select statement and if i pass 1 it will do the update of another datable and give me a select after. But for some reason, the etl reader do not like this. so my work around is to break down this stored procedure into two .. one can just plain select and one for update.

Thank you.

another thing, after the reader execute the stored procedure one of the column returns with path location value ..i.e '\\DEV01\images\img001\abc.tif'
so how do i grab just the path without the file - '\\DEV01\images\img001\'