Can i get a int value from a table and assign that value to variable or just directly get the value from table to use as input parameter in stored procedure in SSIS RRS feed

  • Question

  • Hi I have created a table where i am inserting some records for variable so that i don't need to touch ssis to change the variable value. Those variable value was hard coded Int value before. I also use those variable value to execute store procedure. But the issue is : Stored procedure parameter as Int and if i us "Select  ID from Table" in variable @ID expression  i must give data type as String so when I execute Stored Procedure in EXEC sql task where SQL command = Exec My_StoredProc,?. I get an error that :An error occurred while extracting the result into a variable of type (DBTYPE_I4):


    • Moved by Dave PatrickMVP Monday, August 31, 2020 9:47 PM looking for forum
    Monday, August 31, 2020 8:34 PM