I am using UNC Jeff but I found something new.
When I run the package on desktop through Visual Studio, it is a success.
When I run it the package on desktop through SSMS, it said that it is a success but it really isn't activate.
When I run it the package on Server (remote in) through SSMS, it said that all tasks failed.
Here are some of the errors. Do I need to install OLEDB?
OnError View Context 8/14/2019 3:34:18 PM "Data Flow Task:Error: One or more component failed validation.
" Data Flow Task
OnError View Context 8/14/2019 3:34:18 PM "Data Flow Task:Error: There were errors during task validation.
" Data Flow Task
OnError View Context 8/14/2019 3:34:18 PM "Second:Error: 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"".
"
OnError View Context 8/14/2019 3:34:18 PM "Data Flow Task:Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager ""Excel Connection Manager 1"" failed with error code 0xC0209303. There may be error messages posted before this with more information on why the AcquireConnection method call failed.
" Data Flow Task
OnError View Context 8/14/2019 3:34:18 PM "Data Flow Task:Error: Excel Source 1 failed validation and returned error code 0xC020801C.
" Data Flow Task