?
Solved

SISS Package Error

Posted on 2007-07-31
1
Medium Priority
?
631 Views
Last Modified: 2013-11-30
I've got an SISS package that runs fine when I execute it manually

But if I try to execute it using command line (dtexec /F "c:\UpdateSQLFromComtrak.dtsx")

or via a job I get a connection manager error message which I'e copied below. I've no idea what is causing this as when I execute the package manually it uses the same connection manager so why would it fail?


================================================================================================
Error: 2007-07-31 13:47:22.98
   Code: 0xC0202009
   Source: ed_test2_import_live Connection manager "C:\CommTrak\CommTrakPort.acc
db"
   Description: SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred.
 Error code: 0x80040154.
An OLE DB record is available.  Source: "Microsoft OLE DB Service Components"  H
result: 0x80040154  Description: "Class not registered".
End Error
Error: 2007-07-31 13:47:23.00
   Code: 0xC020801C
   Source: Data Flow Task Source - qryOCTApplicant [1]
   Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAG
ER.  The AcquireConnection method call to the connection manager "C:\CommTrak\Co
mmTrakPort.accdb" failed with error code 0xC0202009.  There may be error message
s posted before this with more information on why the AcquireConnection method c
all failed.
End Error
Error: 2007-07-31 13:47:23.00
   Code: 0xC0047017
   Source: Data Flow Task DTS.Pipeline
   Description: component "Source - qryOCTApplicant" (1) failed validation and r
eturned error code 0xC020801C.
End Error
Progress: 2007-07-31 13:47:23.01
   Source: Data Flow Task
   Validating: 55% complete
End Progress
Error: 2007-07-31 13:47:23.01
   Code: 0xC004700C
   Source: Data Flow Task DTS.Pipeline
   Description: One or more component failed validation.
End Error
Error: 2007-07-31 13:47:23.01
   Code: 0xC0024107
   Source: Data Flow Task
   Description: There were errors during task validation.
End Error
DTExec: The package execution returned DTSER_FAILURE (1).
Started:  1:47:22 pm
Finished: 1:47:23 pm
Elapsed:  0.625 seconds============================================================================
-------------------------------------------------------------------------------------------------------------------------------------------------------------
0
Comment
Question by:Ed
1 Comment
 
LVL 43

Accepted Solution

by:
Eugene Z earned 2000 total points
ID: 19613350
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ready to get certified? Check out some courses that help you prepare for third-party exams.
Microsoft provides a rich set of technologies for High Availability and Disaster Recovery solutions.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…
Suggested Courses

601 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question