June 18, 2010 at 8:44 am
Hi Guys,
Kindly help with this issue.
Regards
Durai Nagarajan
June 22, 2010 at 4:18 pm
Hi Durani
Am not exactly aware of how to do this, but this is a thought you may want to consider.
Create a template file and copy that over every time the package runs and import the new data in and rename the file if needed...
This way you will have a blank sheet every time...
Let me know if you need help with this and I will try...
Cheers
Vani
June 23, 2010 at 12:13 am
I dont think you can delet data from the excel file from the SSIS Excel Destination.
You could creat a script task that runs before the DFT which does the job: opens the excel file and runs a macro that deletes all data in the desired sheet.
Your script could read as follows (be aware this is just written code, not tested)
- I Assume you have a variable named "ExcelFileName" that contains the name of your file
- I assume that you have Excel installed on the machine your SSIS package runs on
Dim ExcelFileName As String = (Dts.Variables("ExcelFileName").Value)
Dim ExcelApp As Object
Dim wb As Object
Try
ExcelApp = CreateObject("Excel.Application")
wb = ExcelApp.Workbooks.Open(ExcelFileName, 2, True)
wb.Sheets("YourSheetName").Range("A1-IV65535").Clear
Catch ex As Exception
Dts.TaskResult = Dts.Results.Failure
Finally
If Not (wb Is Nothing) Then wb.Close(False)
wb = Nothing
ExcelApp.Quit()
ExcelApp = Nothing
End Try
Unfortunately, without excel installed, this won't work...
Viewing 3 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply