whgsystems
asked on
How do I delete data in Excel through a BIDS package
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)
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)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
>>Delete doesn't work, nor does Drop Table, in the package.<<
I suspect what was meant was that you delete the (spreadsheet) file.
I suspect what was meant was that you delete the (spreadsheet) file.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I tried everything suggested beforehand so no real solution but the answers where correct if somewhat short and lacking in examples
ASKER
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.