[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


How do I delete data in Excel through a BIDS package

Posted on 2011-04-19
Medium Priority
Last Modified: 2012-05-11
I can create and populate an Excel spreadsheet thru a SSIS package.
I can append data to the sheet from a SQL view, but in the package I cannot Drop or Delete the data in the spreadsheet first.
The package is to be run daily.
How do I delete (or drop) the spreadsheet before repopulating the table. I keep getting 'Table "xxxx" does not exist' - (table or sheet)
Question by:whgsystems
  • 2
  • 2
LVL 21

Accepted Solution

Alpesh Patel earned 2000 total points
ID: 35424400
Before populate data in excel sheet. first delete excel and create new each and every run.

Author Comment

ID: 35424880
Thanks PatelAlpesh but ..
Delete doesn't work, nor does Drop Table, in the package.
Cannot manually delete every day.
Need to clear (or remove) spreadsheet thru a SSIS package before creating new.

LVL 75

Expert Comment

by:Anthony Perkins
ID: 35429230
>>Delete doesn't work, nor does Drop Table, in the package.<<
I suspect what was meant was that you delete the (spreadsheet) file.
LVL 21

Assisted Solution

by:Alpesh Patel
Alpesh Patel earned 2000 total points
ID: 35430643
Hey you can delete any of file using SSIS. (File System Task is there to satisfy your need)

Author Closing Comment

ID: 35483256
I tried everything suggested beforehand so no real solution but the answers where correct if somewhat short and lacking in examples

Featured Post

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Suggested Courses

872 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question