Комментарии:
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?
Thank you for video… could I know how do got tables from excel to sql server.
ОтветитьThank you for the video...but please switch off that mouse click sound !!! :)
Ответить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?/
Ответить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
Can we do this task without putting an entry in the sheet table?
Ответить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?
another great video. many thanks Amir Bhai
ОтветитьWhen u wake up and u find techbro’s Notifications. Your day is really made
I love u man !