SSIS Not running in command window... not registered

Larry Brister
Larry Brister used Ask the Experts™
on
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\Package.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_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER.  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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
SQL Server DBA & Architect, EE Solution Guide
Awarded 2009
Distinguished Expert 2018
Commented:
>> I have tried setting the package to 32 bit
"C:\Program Files\Microsoft SQL Server\140\DTS\Binn\DTEXEC.exe"

If you have converted your package to 32 bit, then try running the package from Command prompt by calling 32 bit version of dtexec.exe..
The one you are using above is 64 bit version of dtexec.exe and hence getting errors.
32bit => C:\Program Files (x86)\Microsoft SQL Server\140\DTS\Binn\DTExec.exe
64bit => C:\Program Files\Microsoft SQL Server\140\DTS\Binn\DTExec.exe

More info on how to troubleshoot the 32 bit vs 64 bit excel issues here..
http://microsoft-ssis.blogspot.com/2012/09/swtich-package-from-64bit-to-32bit.html
Larry Bristersr. Developer

Author

Commented:
Perfect
Thanks
Raja Jegan RSQL Server DBA & Architect, EE Solution Guide
Awarded 2009
Distinguished Expert 2018

Commented:
Welcome, glad to assist!!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial