I am facing an error with the excel file source to write data from excel source to azure SQL destination table.
catalog.set_execution_credential @domain= N'Azure', @user= N'mystorageaccount', @password= N'storagekey'
After deploy and execute the package.dtsx I got the following errors:
1. Data Flow Task:Error:There were errors during task validation. 2. Data Flow Task:Error:One or more component failed validation. 3. Data Flow Task:Error: Excel Source failed validation and returned error code 0xC020801C 4. Data Flow Task:Error: SSIS Error Code *DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER*.The AcquireConnection method call to the connection manager "Excel Connection Manager" failed with error code 0xC0202009. 5. Error SSIS Error Code DTS_E_OLEDBERROR.An OLE DB error has occurred.Error Code 0x80004005.An OLE DB record is available. Source "Microsoft Access Database Engine " *Hresult:0x8004005 Description "Z\Product.xlsx*" is not a valid path. Make sure that the paths name is specified correctly and that you are connected to the server on which the file resides
User contributions licensed under CC BY-SA 3.0