Is it possible to delete rows in an excel worksheet from SSIS?
+2
A:
From forum
- create a file system task in control flow, deleting the file.
- 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
- left my previous export object the same, then linked the flow of these in this order described.
Gulzar
2008-10-28 17:58:02
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
2009-01-06 21:51:55