SISS Package Error

Posted on 2007-07-31
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
   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]
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============================================================================
Question by:edjones1
    1 Comment
    LVL 42

    Accepted Solution


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
    JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
    This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
    Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

    760 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

    Need Help in Real-Time?

    Connect with top rated Experts

    10 Experts available now in Live!

    Get 1:1 Help Now