 | |
Export to excel (Overwrite not append)
microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts
 |
| | Thread Tools | Display Modes |
#21
 
| |||
| |||
|
Re: Export to excel (Overwrite not append) -
06-24-2008
, 09:51 PM
|
On Jun 24, 9:16 am, Nigel <Ni... (AT) discussions (DOT) microsoft.com> wrote: I have created a DTS package that exports to an excel file. The problem I am getting is that this dts package need to runs once a day and it appends the data each time it runs. I need it to Truncate the Data in the excel file before copying the new data to it. Does enyone know how to truncate an Excel file using dts? -- Regards Nigel Hi Nigel, i faced the same problem and didn't find a way to truncate the file. Anyway, you can work around it: Either you can create an execute process task that deletes the file before (OnSuccess/OnCompletition) the "export" task or you can create the excel with a different filename every time. I preferred the first. Hope this hepls M. |
#22
| |||
| |||
|
|
On Jun 24, 9:16 am, Nigel <Ni... (AT) discussions (DOT) microsoft.com> wrote: I have created a DTS package that exports to an excel file. The problem I am getting is that this dts package need to runs once a day and it appends the data each time it runs. I need it to Truncate the Data in the excel file before copying the new data to it. Does enyone know how to truncate an Excel file using dts? -- Regards Nigel Hi Nigel, i faced the same problem and didn't find a way to truncate the file. Anyway, you can work around it: Either you can create an execute process task that deletes the file before (OnSuccess/OnCompletition) the "export" task or you can create the excel with a different filename every time. I preferred the first. Hope this hepls M. |
#23
| |||
| |||
|
|
On Jun 24, 9:16 am, Nigel <Ni... (AT) discussions (DOT) microsoft.com> wrote: I have created a DTS package that exports to an excel file. The problem I am getting is that this dts package need to runs once a day and it appends the data each time it runs. I need it to Truncate the Data in the excel file before copying the new data to it. Does enyone know how to truncate an Excel file using dts? -- Regards Nigel Hi Nigel, i faced the same problem and didn't find a way to truncate the file. Anyway, you can work around it: Either you can create an execute process task that deletes the file before (OnSuccess/OnCompletition) the "export" task or you can create the excel with a different filename every time. I preferred the first. Hope this hepls M. |
#24
| |||
| |||
|
|
On Jun 24, 9:16 am, Nigel <Ni... (AT) discussions (DOT) microsoft.com> wrote: I have created a DTS package that exports to an excel file. The problem I am getting is that this dts package need to runs once a day and it appends the data each time it runs. I need it to Truncate the Data in the excel file before copying the new data to it. Does enyone know how to truncate an Excel file using dts? -- Regards Nigel Hi Nigel, i faced the same problem and didn't find a way to truncate the file. Anyway, you can work around it: Either you can create an execute process task that deletes the file before (OnSuccess/OnCompletition) the "export" task or you can create the excel with a different filename every time. I preferred the first. Hope this hepls M. |
#25
| |||
| |||
|
|
On Jun 24, 9:16 am, Nigel <Ni... (AT) discussions (DOT) microsoft.com> wrote: I have created a DTS package that exports to an excel file. The problem I am getting is that this dts package need to runs once a day and it appends the data each time it runs. I need it to Truncate the Data in the excel file before copying the new data to it. Does enyone know how to truncate an Excel file using dts? -- Regards Nigel Hi Nigel, i faced the same problem and didn't find a way to truncate the file. Anyway, you can work around it: Either you can create an execute process task that deletes the file before (OnSuccess/OnCompletition) the "export" task or you can create the excel with a different filename every time. I preferred the first. Hope this hepls M. |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.