March 26, 2013 at 6:19 pm
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 ??
March 27, 2013 at 2:19 am
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 filei'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.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
March 27, 2013 at 3:23 pm
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:
March 27, 2013 at 7:04 pm
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
April 24, 2013 at 8:04 am
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.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply