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
*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 ??
[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.
Help us to help you. For better, quicker and more-focused answers to your questions, consider following the advice in this
If the answer to your question can be found with a brief Google search, please perform the search yourself, rather than expecting one of the SSC members to do it for you.
Please surround any code or links you post with the appropriate IFCode formatting tags. It helps readability a lot.