ssis query through variable

  • I have an 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.

    Thanks

  • The best way to go about these situations is to first try the query without the variable. Then, if it works, substitute the variable in.

    From what you've said, it sounds like your problem is more in terms of the query itself, not the variable. Are you sure you've got the right table names, connection info, etc?

  • I hope you are aware that an interop is a .net assembly that routes calls from a .net application to a COM component. It does not contain the COM component. The COM component must exist on the machine.

    In your case I guess the COM component that you are referencing gets installed with windows messenger/live messenger. If it does not exist on the target machine, you'll get the error you are getting.

    More on interops

    http://msdn.microsoft.com/en-us/library/aa302338.aspx

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply