I have tried setting my provider to Microsoft.Jet.OLEDB.4.0 and I am still getting the "Class Not Registered" error as well. I am trying to do some simple data conversions during the import to sql.

Can someone please help!!

Here is a dump of the return.

Microsoft (R) SQL Server Execute Package Utility

Version 9.00.3042.00 for 64-bit

Copyright (C) Microsoft Corp 1984-2005. All rights reserved.

Started: 3:27:50 PM

Progress: 2008-08-07 15:27:52.04

Source: Step1_6tbls

Validating: 0% complete

End Progress

Error: 2008-08-07 15:27:52.25

Code: 0xC0202009

Source: Liberty2007 Connection manager "SourceConnectionOLEDB"

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: 2008-08-07 15:27:52.25

Code: 0xC020801C

Source: Step1_6tbls Source - tbAgent [1]

Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAG

ER. The AcquireConnection method call to the connection manager "SourceConnecti

onOLEDB" failed with error code 0xC0202009. There may be error messages posted

before this with more information on why the AcquireConnection method call faile

d.

End Error

Error: 2008-08-07 15:27:52.25

Code: 0xC0047017

Source: Step1_6tbls DTS.Pipeline

Description: component "Source - tbAgent" (1) failed validation and returned

error code 0xC020801C.

End Error

Progress: 2008-08-07 15:27:52.25

Source: Step1_6tbls

Validating: 5% complete

End Progress

Error: 2008-08-07 15:27:52.25

Code: 0xC004700C

Source: Step1_6tbls DTS.Pipeline

Description: One or more component failed validation.

End Error

Error: 2008-08-07 15:27:52.26

Code: 0xC0024107

Source: Step1_6tbls

Description: There were errors during task validation.

End Error

DTExec: The package execution returned DTSER_FAILURE (1).

Started: 3:27:50 PM

Finished: 3:27:52 PM

Elapsed: 2.313 seconds