We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

How do I delete data in Excel through a BIDS package

Medium Priority
239 Views
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)
Comment
Watch Question

Solution Architect at TCS (SAFe®Agilist, TOGAF® Foundation, PSM I®, MCP, MCSD)
CERTIFIED EXPERT
Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview

Author

Commented:
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.

CERTIFIED EXPERT
Top Expert 2012

Commented:
>>Delete doesn't work, nor does Drop Table, in the package.<<
I suspect what was meant was that you delete the (spreadsheet) file.
Alpesh PatelSolution Architect at TCS (SAFe®Agilist, TOGAF® Foundation, PSM I®, MCP, MCSD)
CERTIFIED EXPERT
Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview

Author

Commented:
I tried everything suggested beforehand so no real solution but the answers where correct if somewhat short and lacking in examples
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a free trial preview!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.