 | |
SSIS 2005 - Excel Destination
microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts
 |
| | Thread Tools | Display Modes |
#11
 
| |||
| |||
|
Re: SSIS 2005 - Excel Destination -
09-19-2008
, 08:06 AM
|
On Sep 18, 9:56 pm, Daniela <Dani... (AT) discussions (DOT) microsoft.com> wrote: Hi, I am new to SSIS. I created a pockage that extracts data from SQL and export to an Excel spreadsheet. This package will run every day. The problem is that when I execute the package the new data is appended to the end of the spreadsheet. I need SSIS to overwrite the spreadsheet everytime it runs. Any ideas on how I could solve it. Please be as detailed as possible since I am not very familiar with SSIS. Thanks Ciao Daniela, this thread in microsoft.public.sqlserver.dts should fit your needs: http://groups.google.com/group/micro...491c09f86075d9 Let me know if you need help M. |
#12
| |||
| |||
|
|
On Sep 18, 9:56 pm, Daniela <Dani... (AT) discussions (DOT) microsoft.com> wrote: Hi, I am new to SSIS. I created a pockage that extracts data from SQL and export to an Excel spreadsheet. This package will run every day. The problem is that when I execute the package the new data is appended to the end of the spreadsheet. I need SSIS to overwrite the spreadsheet everytime it runs. Any ideas on how I could solve it. Please be as detailed as possible since I am not very familiar with SSIS. Thanks Ciao Daniela, this thread in microsoft.public.sqlserver.dts should fit your needs: http://groups.google.com/group/micro...491c09f86075d9 Let me know if you need help M. |
#13
| |||
| |||
|
|
On Sep 18, 9:56 pm, Daniela <Dani... (AT) discussions (DOT) microsoft.com> wrote: Hi, I am new to SSIS. I created a pockage that extracts data from SQL and export to an Excel spreadsheet. This package will run every day. The problem is that when I execute the package the new data is appended to the end of the spreadsheet. I need SSIS to overwrite the spreadsheet everytime it runs. Any ideas on how I could solve it. Please be as detailed as possible since I am not very familiar with SSIS. Thanks Ciao Daniela, this thread in microsoft.public.sqlserver.dts should fit your needs: http://groups.google.com/group/micro...491c09f86075d9 Let me know if you need help M. |
#14
| |||
| |||
|
|
On Sep 18, 9:56 pm, Daniela <Dani... (AT) discussions (DOT) microsoft.com> wrote: Hi, I am new to SSIS. I created a pockage that extracts data from SQL and export to an Excel spreadsheet. This package will run every day. The problem is that when I execute the package the new data is appended to the end of the spreadsheet. I need SSIS to overwrite the spreadsheet everytime it runs. Any ideas on how I could solve it. Please be as detailed as possible since I am not very familiar with SSIS. Thanks Ciao Daniela, this thread in microsoft.public.sqlserver.dts should fit your needs: http://groups.google.com/group/micro...491c09f86075d9 Let me know if you need help M. |
#15
| |||
| |||
|
|
On Sep 18, 9:56 pm, Daniela <Dani... (AT) discussions (DOT) microsoft.com> wrote: Hi, I am new to SSIS. I created a pockage that extracts data from SQL and export to an Excel spreadsheet. This package will run every day. The problem is that when I execute the package the new data is appended to the end of the spreadsheet. I need SSIS to overwrite the spreadsheet everytime it runs. Any ideas on how I could solve it. Please be as detailed as possible since I am not very familiar with SSIS. Thanks Ciao Daniela, this thread in microsoft.public.sqlserver.dts should fit your needs: http://groups.google.com/group/micro...491c09f86075d9 Let me know if you need help M. |
#16
| |||
| |||
|
|
On Sep 18, 9:56 pm, Daniela <Dani... (AT) discussions (DOT) microsoft.com> wrote: Hi, I am new to SSIS. I created a pockage that extracts data from SQL and export to an Excel spreadsheet. This package will run every day. The problem is that when I execute the package the new data is appended to the end of the spreadsheet. I need SSIS to overwrite the spreadsheet everytime it runs. Any ideas on how I could solve it. Please be as detailed as possible since I am not very familiar with SSIS. Thanks Ciao Daniela, this thread in microsoft.public.sqlserver.dts should fit your needs: http://groups.google.com/group/micro...491c09f86075d9 Let me know if you need help M. |
#17
| |||
| |||
|
|
On Sep 18, 9:56 pm, Daniela <Dani... (AT) discussions (DOT) microsoft.com> wrote: Hi, I am new to SSIS. I created a pockage that extracts data from SQL and export to an Excel spreadsheet. This package will run every day. The problem is that when I execute the package the new data is appended to the end of the spreadsheet. I need SSIS to overwrite the spreadsheet everytime it runs. Any ideas on how I could solve it. Please be as detailed as possible since I am not very familiar with SSIS. Thanks Ciao Daniela, this thread in microsoft.public.sqlserver.dts should fit your needs: http://groups.google.com/group/micro...491c09f86075d9 Let me know if you need help 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.