I've seen all the posts (hundreds of them) concerning the fact that the Microsoft Jet OLEDB 4.0 provider only works on 32-Bit systems. ÃÂ Really? ÃÂ I'm running Windows Server 2008 Data Center and have an urgent need to run an SQL Job that needs to query an Access database. ÃÂ The job runs DTExec to execute an SSIS package (the Job step is configured with the "Use 32 bit runtime" checked (set to true)). ÃÂ I am getting the follwing error message when I'm on the part of the SSIS package, which is an 'Execute SQL Task', which attempts to open the Access Database:ÃÂ
DTExec: The package execution returned DTSER_FAILURE (1).
Started: ÃÂ 2:31:08 PM
Finished: 2:31:12 PM
Elapsed: ÃÂ 4.438 seconds
Microsoft (R) SQL Server Execute Package Utility
Version 10.0.1787.0 for 32-bit
Copyright (C) Microsoft Corp 1984-2005. All rights reserved.
Started: ÃÂ 2:37:14 PM
Error: 2009-04-30 14:37:19.13
ÃÂ ÃÂ Code: 0xC002F210
ÃÂ ÃÂ Source: DoDeletes Execute SQL Task
ÃÂ ÃÂ Description: Executing the query "DELETE From [dbo].[zsong] where [MUZENBR] in (
SE..." failed with the following error: "The OLE DB provider "Microsoft.Jet.OLEDB.4.0" has not been registered.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
DTExec: The package execution
View Complete Post