Execute SQL Task to Delete Rows from a Excel Sheet

• ganteng1

  Ten Centuries

  Points: 1183

  More actions

  May 8, 2014 at 5:06 pm

  #307667

  Hi Everyone.

  Is there a way to delete rows in an excel spreadsheet using the execute SQL Task in SSIS?

  Thanks and Regards

• Umer Akram

  SSC-Insane

  Points: 22209

  More actions

  May 9, 2014 at 1:58 am

  #1712073

  For you question you cannot delete rows from excel using t-sql, you can only update the rows to empty.

  can you explain your scenario in detail why u want to delete the rows from excel?