Load Excel File with Multiple Sheets Dynamically by using Lookup Activity in Azure Data Factory 2021

Load Excel File with Multiple Sheets Dynamically by using Lookup Activity in Azure Data Factory 2021

TechBrothersIT

2 года назад

17,461 Просмотров

Ссылки и html тэги не поддерживаются


Комментарии:

@apurvasharma645
@apurvasharma645 - 08.11.2022 23:56

My pipeline is failing because of 'Worksheet doesnt found'. I want pipeline to ignore file which doesnt have sheetname and pick only which have sheetname in it.
Is it possible to do in ADF?

Ответить
@sharathchandra2522
@sharathchandra2522 - 25.10.2022 19:04

Thank you for video… could I know how do got tables from excel to sql server.

Ответить
@Nappa74
@Nappa74 - 09.06.2022 12:08

Thank you for the video...but please switch off that mouse click sound !!! :)

Ответить
@jahanvitiwari5083
@jahanvitiwari5083 - 04.03.2022 13:23

for some reason my table is not getting loaded with any rows except the top header row i also checked and have the top row only option deselected.. what could be the problem?/

Ответить
@garysankar7213
@garysankar7213 - 05.01.2022 22:29

Getting this error and tried several fixes but none work. Any suggestions?
Error
Notifications
Operation on target ForEach1 failed: Activity failed because an inner activity failed; Inner activity name: Copy data1, Error: ErrorCode=ExcelInvalidSheet,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=The worksheet cannot be found by name:'wu_Category_Review_Update' or index:'-1' in excel file 'Weekly Updates.xlsx'.,Source=Microsoft.DataTransfer.ClientLibrary,'


Thanks

Ответить
@sahilgupta006
@sahilgupta006 - 17.10.2021 16:27

Can we do this task without putting an entry in the sheet table?

Ответить
@stefanorossip
@stefanorossip - 15.10.2021 18:02

Really good. Thank you!!
One question: what happens if I have 5 Sheetnames on my Azure SQL table and the excel file that is being read only has 3 of those 5. Would it still work?

Ответить
@Global-Post
@Global-Post - 01.09.2021 13:08

another great video. many thanks Amir Bhai

Ответить
@zakariiabadis7203
@zakariiabadis7203 - 01.09.2021 09:00

When u wake up and u find techbro’s Notifications. Your day is really made
I love u man !

Ответить