Error while executing Job schedule

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

SSIS and Import/Export (2008)

Error while executing Job schedule

Author

Topic

asifbhura
Posting Yak Master

165 Posts

Posted - 2011-11-14 : 14:05:12

Hello Everyone,

I have windows server 2008 64 bit

I have sql server 2008 r2 and ms acess 2003 are installed..

I successfully imported data from ms access to sql server.. and save as SSIS package..

I tried to run package from Integrated services.. I did run successfully ..

but, when i create a job, steps and schedule to execute package then it gives error like below

I tried with Jet.4.0 as well but same error.

Executed as user: SCHOOL\JAWAHIR2$.
Microsoft (R) SQL Server Execute Package Utility Version 10.50.1600.1
for 64-bit Copyright (C) Microsoft Corporation 2010.
All rights reserved.
Started: 7:46:32 AM
Error: 2011-11-14 07:46:32.85
Code: 0xC0209303
Source: JARISDBPACK Connection manager "SourceConnectionOLEDB"
Description: SSIS Error Code DTS_E_OLEDB_NOPROVIDER_64BIT_ERROR.
The requested OLE DB provider Microsoft.ACE.OLEDB.12.0 is not registered
-- perhaps no 64-bit provider is available.
Error code: 0x00000000. An OLE DB record is available.
Source: "Microsoft OLE DB Service Components"
Hresult: 0x80040154
Description: "Class not registered".
End Error Error: 2011-11-14 07:46:32.85
Code: 0xC020801C
Source: Data Flow Task 1 Source - StdInfo [1]
Description:
SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER.
The AcquireConnection method call to the connection manager
"SourceConnectionOLEDB" failed with error code 0xC0209303.
There may be error messages posted before this with more information on
why the AcquireConnection method call failed.
End Error Error: 2011-11-14 07:46:32.85
Code: 0xC0047017
Source: Data Flow Task 1 SSIS.Pipeline
Description: component "Source - StdInfo"
(1) failed validation and returned error code 0xC020801C.
End Error Error: 2011-11-14 07:46:32.85
Code: 0xC004700C
Source: Data Flow Task 1 SSIS.Pipeline
Description: One or more component failed validation.
End Error Error: 2011-11-14 07:46:32.85
Code: 0xC0024107 Source: Data Flow Task 1
Description: There were errors during task validation.
End Error
DTExec: The package execution returned DTSER_FAILURE (1).
Started: 7:46:32 AM Finished: 7:46:32 AM
Elapsed: 0.296 seconds.
The package execution failed. The step failed.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-11-14 : 23:53:16

are you using dtexec to execute the package from job? it seems its using 64 bit runtime for package running which doesnt support Microsoft.ACE.OLEDB.12.0 provider you're using for excel connection. What you can try is to tweak the dtexec call as follows

dtexec.... (other options) /X86

if you're not using dtexec but just configured to call package in sql job then go to execution options tab and select the property Use 32bit runtime

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources