SSIS With Azure Sql Excel Source Failed Validation Error After deploy


I am facing an error with the excel file source to write data from excel source to azure SQL destination table.

  1. I created File Share in storage account.
  2. Add this account name and key in Window Credentials.
  3. Right click This PC and choose Map Network drive with storage account and account key.
  4. Then set my product.xlsx file under the map network drive Z.
  5. Excel source connection manager get file Procuct.xlsx under Z.
  6. And Run 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
asked on Stack Overflow Nov 28, 2020 by May Thu • edited Dec 1, 2020 by Pierre.Vriens

0 Answers

Nobody has answered this question yet.

User contributions licensed under CC BY-SA 3.0