I'm using a stored procedure in Execute SQL task which return a query something like
select * from store where store_id in (3,6)
I then assigned this output to a variable Variable and try to run this query using
OLE DB Source with the option SQL command from variable.
But i get an error
[Execute SQL Task] Error: An error occurred while assigning a value to variable "Variable": "Exception from HRESULT: 0xC0015005".
Where am i going wrong? please guide me.
View Complete Post