August 25, 2005 at 12:36 pm
Hi,
I'm exporting a table into excel where the destination is "Results", it creates a new excel sheet it works well..but when i mention destination as into an exisitng sheet (viz. Sheet1$ or Sheet2$), it exports only first column data from the source table. And also when i look into transform..it shows first column mapped to "F1" and second column onwards it shows "ignore" under destination.
Urgent help required.
TIA
August 29, 2005 at 8:00 am
This was removed by the editor as SPAM
August 29, 2005 at 9:07 am
Havnen't seen the "ignore" part. Are you building the transform by hand or using the wizard?
September 1, 2005 at 11:24 am
I've found you need to delete and recreate the worksheet each time you do the export. Create an Execute SQL task bound to the connection to your Excel spreadsheet and in it put something like:
DROP TABLE `worksheet_name`
GO
CREATE TABLE `worksheet_name` (
`Field1` Byte ,
`Field2` Long ,
`Field3` DateTime,
`Field4` VarChar(10))
Where Fieldn corresponds to the existing column headers.
Good luck
--
Scott
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply