31 How to delete a row from Excel file using SSIS | How to delete a row from Excel file using C#

preview_player
Показать описание
How to delete a row from Excel file using SSIS
Download the file\script used in the Video from below link

How to delete a row from Excel file using SSIS
How do I delete a row from a table in SSIS?
How do I truncate Excel data in SSIS?
How do you delete a column in Excel using C#?
C# and excel deleting rows - Stack Overflow
How do you delete a row in a worksheet?

Happy Learning.

Рекомендации по теме
Комментарии
Автор

Exactly what I needed, even the exact row! Thank you

nthan
Автор

Hi Aqil,
Perfect video, this is what I was looking for, I got the code working for my task.
but I have a question: What can I change in this code if I want to delete all rows from the worksheet except the header.

Thanks!

fareedahmad
Автор

hi Ahmad,
when showing in script task its really difficult to understand as iam not aware of c#.please try to do other than script task.

bschoudary
Автор

Hi Aqil,
How do we delete multiple rows in one worksheet only?

sunaymandeda
Автор

I want to do the same for multiple files in a folder. Please suggest.

SagarSagarsoftware
Автор

what if i was using SSIS 2012 and the same for the VS

ExonaQ
Автор

The problem with this dll, is that only works local, you need to install office on server. Is there another dll that do not require server modification? ty

rominasuarez
Автор

It gives me this error when i call the ssis pkg with this script

Retrieving the com class factory for component with clsid xxx failed due to following error 80040154
Class not registered regdb_e_classnotreg... can you please help

shailjabanka
Автор

If I need to delete from row no 1-4 then .?

shamshadahmad
Автор

what would the code be to delete worksheets?

ryanmascarenhas
Автор

this is working for me in local, but after deployment the package is failing. the file is not accessible it seems. i gave access permission as well. has anyone faced the same pls help

lakshmimohanan
Автор

I want to delete first 5 rows and last row from excel, how to do that

applabsuser
Автор

I am using 2010 SSIS and it is not showing Nuget reference option

sajidrazakhan
visit shbcf.ru