views:

2560

answers:

2

Is it possible to delete rows in an excel worksheet from SSIS?

+2  A: 

From forum

  1. create a file system task in control flow, deleting the file.
  2. create a sql task, excel connection type, i used my previous excel connection for this, then used a create table script as my sql statement
  3. left my previous export object the same, then linked the flow of these in this order described.
Gulzar
A: 

An arctile by microsoft claims that you cannot delete an entire row however you can delete a value in a cell. http://support.microsoft.com/kb/257819

This thread relates to someone with the same problem: http://www.tech-archive.net/Archive/DotNet/microsoft.public.dotnet.framework.adonet/2006-12/msg00245.html

In short, it seems like the answer is 'no', you cannot delete an entire row using ado.net via SSIS. You may be able to use excel automation or vb.net in excel itself to accomplish this task.

Jobo