how to overite excel specific sheet data using SSIS

Question

how to overite excel specific sheet data using SSIS

waheed.azhar

Grasshopper

Points: 23
More actions
January 1, 2008 at 11:14 pm

#154039

I made a SSIS package which extract data using query from SQL Server 2005 and then export it to specific Excel sheet but each time when i run package data keep on appending to specific sheet but i want to do something that each time data not append to specific sheet but overite
I hope you all understand what i want to do
please help and guide also
Thanks,
Waheed.

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Michael Earl-395764 SSC Guru Points: 53873 More actions · Answer 1

You can either add a SQL Command task to your control flow that deletes the data in the spreadsheet (just run a DELETE command like you would against any other table).

The option I like to use is to create a copy of the spreadsheet with the appropriate tables in it (and no data) and use an operating system task to overwrite the destination workbook with the blank copy before populating it. I am not sure why I like this option better - I think there is some benefit that I cannot remember right now.

waheed.azhar Grasshopper Points: 23 More actions · Answer 2

I am very new to SQL 2005 Integration Services so i need to know the complete steps how to do this?

just i follow these steps and do what i want...i hope you will understand

Waiting and Thanks,

Waheed.

Michael Earl-395764 SSC Guru Points: 53873 More actions · Answer 3

The File System Task is pretty simple to use. I am sure there are some detailed instructions if you search the web on how to copy a file using it (that is all you need to do).

If you cannot find instructions, install the sample projects for SSIS from Microsoft from your SQL Server install disk.

SQLdevotee SSCarpal Tunnel Points: 4820 More actions · Answer 4

I have done this in past and it is pretty simple. Just check the Over write data in the file option under connection manager tab in your Destination flat file transformation. If you are still confused, reply back with what transformation you have done step by step and I will get back to you step by step what to do.:D

[font="Verdana"]Imagination is more important than knowledge-Albert Einstein[/font]

waheed.azhar Grasshopper Points: 23 More actions · Answer 5

done successfully

Simply i have to add two SQL Tasks 1 to drop created table and 2 to create New table

Thanks all of you.

mamsay Say Hey Kid Points: 701 More actions · Answer 6

hi azhar,

im also facing the same problem. can u explain me in detail how to do this.

thanks in advance