Often we’d like to know the cause of a dehydrated port. I’ve captured the scenario into the following picture (telling a thousand words)
Warning:
===================
EventId: 5740
The adapter “SQL” raised an error message. Details “HRESULT=”0x80040e10″ Description=”Procedure or function ‘bts_Insertxxx expects parameter ‘@xxxId’, which was not supplied.”".
===================
In this case, the dehydration occurs coz the SQL adapter is expecting an ID parameter that wasn’t returned by the stored procedure.
Happy coding 
Advertisement
