SQL Server Performance

Error in DTS Package

Discussion in 'SQL Server DTS-Related Questions' started by ramkumar.mu, Feb 8, 2007.

  1. ramkumar.mu New Member

    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..."
  2. madhuottapalam New Member

  3. ramkumar.mu New Member

  4. Punyabrata New Member

    hi,

    i think...u can get more detail information about the error if enable the log of the DTS




Share This Page