Larry Brister
asked on
SSIS Not running in command window... not registered
I am getting this message when I try and run my SSIS Package in a Command Window
Package runs perfectly fine in debug
I have tried setting the package to 32 bit
And I have downloaded and installed the Access ole dll
Executing this in COmmand Prompt
"C:\Program Files\Microsoft SQL Server\140\DTS\Binn\DTEXEC .exe" /File "C:\EW\SSIS\MyFolder\Packa ge.dtsx"
...blah blah blah...
Error: 2018-12-20 14:34:44.94
Code: 0xC0209303
Source: Package Connection manager "Excel Connection Manager 3"
Description: The requested OLE DB provider Microsoft.Jet.OLEDB.4.0 is not registered. If the 64-bit driver is not installed, run the package in 32-bit mode. Error code: 0x00000000.
An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult: 0x80040154 Description: "Class not registered".
End Error
Error: 2018-12-20 14:34:44.94
Code: 0xC020801C
Source: Send Data to Everyware Get All Events [2]
Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECT IONFROMCON NECTIONMAN AGER. The AcquireConnection method call to the connection manager "Excel Connection Manager 3" 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
Package runs perfectly fine in debug
I have tried setting the package to 32 bit
And I have downloaded and installed the Access ole dll
Executing this in COmmand Prompt
"C:\Program Files\Microsoft SQL Server\140\DTS\Binn\DTEXEC
...blah blah blah...
Error: 2018-12-20 14:34:44.94
Code: 0xC0209303
Source: Package Connection manager "Excel Connection Manager 3"
Description: The requested OLE DB provider Microsoft.Jet.OLEDB.4.0 is not registered. If the 64-bit driver is not installed, run the package in 32-bit mode. Error code: 0x00000000.
An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult: 0x80040154 Description: "Class not registered".
End Error
Error: 2018-12-20 14:34:44.94
Code: 0xC020801C
Source: Send Data to Everyware Get All Events [2]
Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECT
End Error
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Welcome, glad to assist!!
ASKER
Thanks