April 9, 2007 at 10:16 pm
How do I delete records in the destination file in SSIS using BI Development
Studio? Thanks.
April 10, 2007 at 12:09 am
Why do you want to delete the records in the destination file, instead you don't have to port the unrequired data
kapil
April 10, 2007 at 6:21 pm
Because I am running a daily job to do the export to a xls file. But I don't want to append everyday. Instead I want to overwrite and I don't know how to overwrite. Therefore I think of delete before I export.
April 11, 2007 at 4:29 am
Hi, I think you have to delete and create again your xls file by a filesystem object script. Otherwise you can't access the existing xls rows.
April 11, 2007 at 6:31 am
I think there is a property that you can set on the export task to overwrite the file if it exists. This will effectively 'delete' the existing data in the Excel file.
April 11, 2007 at 6:28 pm
Is the Filesystem object script in the SSIS? I tried to find the overwrite property but cannot find it. Can you please tell me where it is? It will be very helpful. Thanks.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply