How to delete Excel rows in SSIS?

Question

Is it possible to delete rows from excel table from SSIS?

Answer 1

From forum

• create a file system task in the control thread by deleting the file.
• create sql task, excel connection type, i used my previous excel connection for this and then used create script table as sql statement
• left my previous export object the same, and then linked the stream of these threads in the described order.

Answer 2

Microsoft's Arctic says you cannot delete a whole row, however you can delete a value in a cell. http://support.microsoft.com/kb/257819

- : http://www.tech-archive.net/Archive/DotNet/microsoft.public.dotnet.framework.adonet/2006-12/msg00245.html

, , "", , ado.net SSIS. excel vb.net excel .

Answer 3

, , , , , - , , :

SQL Server Excel:

: Excel :

, " ":

Excel, " SQL-":

" SQL-" :

. - "Excel"

. , ,

with. The SQL statement was copied from the original export task.

This is basically it. Run it and it should work. My connection to SQL Server is as follows:

My Excel connection that was created when the Export task was created looks like this:

In the "Data Stream" section using the source assistant, the source "OLE DB source" has the following:

And, using Assignment Assistant, the original Excel assignment has the following:

This is the SQL statement that I copied from the original Excel destination: