Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / General / Data Warehousing / September 2005

Tip: Looking for answers? Try searching our database.

Log Import Error

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
RLanoue - 20 Sep 2005 18:17 GMT
I have a data warehouse that imports all of the required profile,
transactions, logs, etc. on a daily basis and has been running fine.  The
other night, I started to receive the following errors during the web log
import.  

My package logging shows:
Step 'DTSStep_CS_DTSLogImps.DTSLogImport_1' failed
Step Error Source: Microsoft Data Transformation Services (DTS) Package
Step Error Description:The task reported failure on execution.
Step Error code: 8004043B
Step Error Help File:sqldts80.hlp
Step Error Help Context ID:700
Step Execution Started: 9/19/2005 6:38:35 PM
Step Execution Completed: 9/19/2005 6:38:44 PM
Total Step Execution Time: 8.532 seconds
Progress count in Step: 0

The SQL job logging shows:
DTSRun OnError:  DTSStep_CS_DTSLogImps.DTSLogImport_1, Error = -2147220421
(8004043B)
  Error string:  The task reported failure on execution.
  Error source:  Microsoft Data Transformation Services (DTS) Package
  Help file:  sqldts80.hlp
  Help context:  700
Error Detail Records:
Error:  -2147220421 (8004043B); Provider Error:  0 (0)
  Error string:  The task reported failure on execution.
  Error source:  Microsoft Data Transformation Services (DTS) Package
  Help file:  sqldts80.hlp
  Help context:  700

The application event viewer has the following:
Event Type:    Error
Event Source:    CSDataWareHouse
Event Category:    None
Event ID:    49176
Date:        9/19/2005
Time:        8:14:49 PM
User:        N/A
Computer:    INCDCPRDWSQL02
Description:
Log Import Task :Failed to import logs for site : StaplesCV

Event Type:    Error
Event Source:    Commerce Server 2002
Event Category:    None
Event ID:    33123
Date:        9/19/2005
Time:        8:14:49 PM
User:        N/A
Computer:    INCDCPRDWSQL02
Description:
Log Import Task did not import any hits

Event Type:    Error
Event Source:    Commerce Server 2002
Event Category:    None
Event ID:    33122
Date:        9/19/2005
Time:        8:14:49 PM
User:        N/A
Computer:    INCDCPRDWSQL02
Description:
Error launching parser.  status code : -2147467259 (-2147467259)

I have searched but can not find anything related to an import process that
was functioning previously.  Has anyone run into this problem before?  Thanks

- Rich
Peter Yang [MSFT] - 21 Sep 2005 04:23 GMT
Hello,

I replied you in  microsoft.public.sqlserver.dts newsgroup. You may want to
go there for follow up.

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

=====================================================

Signature

This posting is provided "AS IS" with no warranties, and confers no rights.


--------------------
| Thread-Topic: Log Import Error
| thread-index: AcW+Bx7V6bTvIaN9TKyz1uqn7me4Ew==
[quoted text clipped - 88 lines]
|
| - Rich
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.