SQLTeam.com | Weblogs | Forums

SSIS Calling from Windows Job


#1

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


#2

What is the path to dtexec.exe? Are you using the one in x86 path?


#3

In batch file I just write this only.

dtexec /f path of SSIS.

and schedule in windows job.

Thanks


#4

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


#5

Thanks It is working now.

You are great :slight_smile: Thank You


#6

Glad you got it working.