Hi Experts,
I am getting error while I am calling SSIS fron Windows job Scheduler.
SSIS Error Code DTS_E_OLEDB_NOPROVIDER_64BIT_ERROR. The requested OLE DB provider MICROSOFT.JET.OLEDB.4.0 is not registered -- perhaps no 64-bit provider is available. Error code: 0x00000000.
I already change in SSIS --> 64Bits to false still it is not working. and I am using dtexec /f function in batch file.
Please help.
Thanks
What is the path to dtexec.exe? Are you using the one in x86 path?
In batch file I just write this only.
dtexec /f path of SSIS.
and schedule in windows job.
Thanks
D:\Hyperion\Automation\Jobs\Clidtata_to_seadata2>dtexec /f D:\SSIS\CLI_SEDATA2\C
LI_SEDATA2\Bin\Deployment\Transfer_Equipment_Dimension.dtsx
Microsoft (R) SQL Server Execute Package Utility
Version 10.50.1600.1 for 64-bit
Copyright (C) Microsoft Corporation 2010. All rights reserved.
Started: 6:19:07 PM
Progress: 2016-05-04 18:19:07.36
Source: Data Flow Task
Validating: 0% complete
End Progress
Error: 2016-05-04 18:19:07.36
Code: 0xC0209303
Source: Transfer_Equipment_Dimension Connection manager "Microsoft Access"
Description: SSIS Error Code DTS_E_OLEDB_NOPROVIDER_64BIT_ERROR. The request
ed OLE DB provider MICROSOFT.JET.OLEDB.4.0 is not registered -- perhaps no 64-bi
t provider is available. Error code: 0x00000000.
An OLE DB record is available. Source: "Microsoft OLE DB Service Components" H
result: 0x80040154 Description: "Class not registered".
End Error
Error: 2016-05-04 18:19:07.36
Code: 0xC020801C
Source: Data Flow Task OLE DB Source 1 [1]
Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAG
ER. The AcquireConnection method call to the connection manager "Microsoft Acce
ss" failed with error code 0xC0209303. There may be error messages posted befor
e this with more information on why the AcquireConnection method call failed.
End Error
Error: 2016-05-04 18:19:07.36
Code: 0xC0047017
Source: Data Flow Task SSIS.Pipeline
Description: component "OLE DB Source 1" (1) failed validation and returned e
rror code 0xC020801C.
End Error
Progress: 2016-05-04 18:19:07.38
Source: Data Flow Task
Validating: 50% complete
End Progress
Error: 2016-05-04 18:19:07.38
Code: 0xC004700C
Source: Data Flow Task SSIS.Pipeline
Description: One or more component failed validation.
End Error
Error: 2016-05-04 18:19:07.38
Code: 0xC0024107
Source: Data Flow Task
Description: There were errors during task validation.
End Error
DTExec: The package execution returned DTSER_FAILURE (1).
Started: 6:19:07 PM
Finished: 6:19:07 PM
Elapsed: 0.078 seconds
Thanks It is working now.
You are great 
Thank You
Glad you got it working.