I have ab oledb source which extract data from ORACLE. The query is coming from a variable (by select sql command from variable.

I have one user variable v1 having value 100

The another variable holds the query (string datatype) like:

"select * from test where id = "+@v1+""

I am getting error as:

Error HRESULT E_FAIL has been returned from a call to a COM component. (Microsoft Visual Studio)

Anybody have any suggestion about this error.