 | |
Export to excel (Overwrite not append)
microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
Export to excel (Overwrite not append) -
06-24-2008
, 02:16 AM
#2
| |||
| |||
|
|
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 |
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.
#3
| |||
| |||
|
|
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 |
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.
#4
| |||
| |||
|
|
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 |
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.
#5
| |||
| |||
|
|
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 |
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.
#6
| |||
| |||
|
|
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 |
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.
#7
| |||
| |||
|
|
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 |
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.
#8
| |||
| |||
|
|
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 |
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.
#9
| |||
| |||
|
|
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 |
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.
#10
| |||
| |||
|
|
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 |
http://groups.google.com/group/micro...4b db5de2e0d9
|
« 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.