SQL Server Performance Forum – Threads Archive
Error in DTS Package
When i executed a package, it failed with the below mentioned error message in Eventviewer. When i searched google i could find lot of error messages related to 80040e14, but nothing relates to the error – (Name – LOADBISUPPLIERPRODUCTDAYCOSTPRICESTOREMAP; Step Name – Extract; SQL Error Number – 0) the error code for this error is 50510. The step this failed is a simple update step…<br /><br />UPDATE TBL_WH_StoreCostPrice <br />SET Eval_Flag = 0<br />where Country_Code = @CountryCode<br /><br />Can you please help me find the problem?<br /><br />attached below is the error from the event viewer…<br /><br />Package Steps execution information:<br /><br /><br />Step ‘DTSStep_DTSExecuteSQLTask_1′ failed<br /><br />Step Error Source: Microsoft Data Transformation Services (DTS) Package<br />Step Error Description:The task reported failure on execution. (Microsoft OLE DB Provider for SQL Server (80040e14): Procedure Failue : Name – LOADBISUPPLIERPRODUCTDAYCOSTPRICESTOREMAP; Step Name – Extract; SQL Error Number – 0)<br />Step Error code: 8004043B<br />Step Error Help File<img src=’/community/emoticons/emotion-7.gif’ alt=’:s’ />qldts80.hlp<br />Step Error Help Context ID:1100<br /><br />Step Execution Started: 08/02/2007 00:11:03<br />Step Execution Completed: 08/02/2007 00:11:03<br />Total Step Execution Time: 0.031 seconds<br />Progress count in Step: 0 <br /><br />For more information, see Help and Support Center at<a target="_blank" href=http://go.microsoft.com/fwlink/events.asp.>http://go.microsoft.com/fwlink/events.asp.</a><br /><br /><br />Thanks,<br />Ram<br /><br />"It is easy to write code for a spec and walk in water, provided, both are freezed…"i am sure u might have seen this link… it is clearly mentioned that this error occur when the row size is greater the allowable size which is 8060 bytes. http://support.microsoft.com/default.aspx/kb/223758 Madhu
Madhu, Not only the error you mentioned above, i have a list of possible errors with error number 80040e14. But the error i get is distinct from all. FYI… List of possible errors with error number 80040e14 http://tutorials.aspfaq.com/8000xxxxx-errors/why-do-i-get-80040e14-errors.html Thanks,
Ram "It is easy to write code for a spec and walk in water, provided, both are freezed…"
hi, i think…u can get more detail information about the error if enable the log of the DTS
]]>