Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rookie_sql
Constraint Violating Yak Guru
443 Posts |
 Posted - 2007-12-06 : 07:04:22
|
| Hi i've got this strange thing happening to when i dump data out from my SSIS package to a excel file, i've 4 column headings but when i run my package and the data gets dumpped out to execl the data is displayed about 4000 rows down in the page.. it does not start at row 2, where row 1 is the column names any one else get this ? |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2007-12-06 : 07:07:31
|
| Are you outputting to an existing excel file? I used to get this in SQL 2000. The only way I found around it is to create a template from scratch and use that. |
 |
|
|
rookie_sql
Constraint Violating Yak Guru
443 Posts |
Posted - 2007-12-06 : 07:13:21
|
| Yes, am trying to fix the bug so am working on a existing excel file. Do you mean there are 2 files for the report the template and the report ? this makes sense as my report file is read only.. |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2007-12-06 : 07:46:40
|
| You create the template yourself and then whenever you output, you save it to a new file based on the template.Unfortunately, even if you delete the data in excel, the next time you write to it from SQL, it seems to start at the last row of the previous write. I never found a way to stop this behaviour except to use a template. |
|
|
|
|
|
|
Data out put in Report