Does anyone know how to delete rows in Excel through SSIS? I have a conditional split that sends the result set to excel. I need the spreedsheet cleared out before it the task runs as it will only append the records.
The work around to this is to create a blank template; use a file task to copy and overwrite your destination; then send your results to the clean file.
Kindest Regards,
Frank Bazan
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply