Lookup failing
hello I have a lookup in my ssis package that uses email as a reference and finds the first and last names of people that are already in our system. I keep getting these errors and I don't understand how to fix them. It has worked in the past but ever since I migrated it to our live server I haven't been able to get it running [Lookup [36]] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E21. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E21 Description: "Invalid input parameter values. Check the status values for detail.". [Lookup [36]] Error: OLE DB error occurred while fetching parameterized rowset. Check SQLCommand and SqlCommandParam properties. [DTS.Pipeline] Error: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "Lookup" (36) failed with error code 0xC0208253. The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. There may be error messages posted before this with more information about the failure. [DTS.Pipeline] Error: SSIS Error Code DTS_E_THREADFAILED. Thread "WorkThread0" has exited with error code 0xC0208253. There may be error messages posted before this with more information on why the thread has exited.
June 22nd, 2011 1:06pm

What is different on the "live server"?Arthur My Blog
Free Windows Admin Tool Kit Click here and download it now
June 22nd, 2011 1:36pm

Hi please check the input parameters. It is complaining about that. Verify that input parameter is not null maybe check with ISNULL() in SQL statement, data type is compatible with the parametrized query i.e one string value could kill everything if parameter is integer. maybe another reason is Development server is 32 bit but live server is 64 bit? (Just guessing) Senior BI Consultant & PM @ Nexum Bogazici If it is, Please dont forget to mark as answered or at least vote as helpful if the post helps you in any ways.
June 22nd, 2011 1:41pm

FYI:Error 0x80040E21 typically means OLEDB cannot carry on a data operation, for example in your case it could be that the database schema in dev vs.prod is different. For example the datatype. Arthur My Blog
Free Windows Admin Tool Kit Click here and download it now
June 22nd, 2011 1:41pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics