SSIS package wont write to excel destination

Question

SSIS package wont write to excel destination

devilsid

SSC Eights!

Points: 830
More actions
March 26, 2013 at 6:19 pm

#270464

i am adding a part to an existing SSIS package which is to write to an excel destination what i see is the package runs but dosen't write to the file
i've checked
*package is running at 32 bit
*all connection managers are working
*using an excel connection and writing to excel 97 -2003 file
exececution results i see is a warning
"[SSIS.Pipeline] Warning: Warning: Could not open global shared memory to communicate with performance DLL; data flow performance counters are not available. To resolve, run this package as an administrator, or on the system's console.
"
am not sure if this should impact ??
also
[SSIS.Pipeline] Information: "component "Excel Destination" (247)" wrote 0 rows.
would appreciate any ideas ??

Viewing 5 posts - 1 through 4 (of 4 total)

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

Phil Parkin SSC Guru Points: 246985 More actions · Answer 1

devilsid (3/26/2013)
i am adding a part to an existing SSIS package which is to write to an excel destination what i see is the package runs but dosen't write to the file
i've checked
*package is running at 32 bit
*all connection managers are working
*using an excel connection and writing to excel 97 -2003 file
exececution results i see is a warning
"[SSIS.Pipeline] Warning: Warning: Could not open global shared memory to communicate with performance DLL; data flow performance counters are not available. To resolve, run this package as an administrator, or on the system's console.
"
am not sure if this should impact ??
also
[SSIS.Pipeline] Information: "component "Excel Destination" (247)" wrote 0 rows.
would appreciate any ideas ??

Don't worry about the warning - it is not related to your problem.

Are you sure that data is flowing through the pipeline? Try using a data viewer to verify this.

The absence of evidence is not evidence of absence.
Martin Rees

You can lead a horse to water, but a pencil must be lead.
Stan Laurel

devilsid SSC Eights! Points: 830 More actions · Answer 2

Thanks Phil,

i thought so the warning wasn't relevant ...

i do have a data viewer in place that is just before the data exports to excel ... surprisingly all steps go green and the data viewer dosen't even pop up??? :ermm:

devilsid SSC Eights! Points: 830 More actions · Answer 3

Got this working ... not sure if i did anything different ...

the data viewer still dosen't pop up also i noticed the export leaves about top 400+ lines blank while exporting data into the excel sheet ... not a big issue but annoying

aaron.reese SSChampion Points: 13498 More actions · Answer 4

The blank lines may be because it starts the insert from the end of the Excel file. Although there was no data in the excel file, the xlCellTypeLastUsedCell property may still have been set. Try deleting the spreadsheet and creating a new one with the same name.