SSIS logging OnPipelinePreEndOfRowset and OnPipelineRowsSent propblem
I have an SSIS project written in SS-2008 and ported over to SS-2012. In 2008 the package runs fine in development and from the command line. In 2012 the package runs fine in
the SSIS development environment, but when I try to execute it using DTEXEC I am getting a thousands of lines of:
The event "OnPipelinePreEndOfRowset" was received, but didn't have correct parameters.
The event "OnPipelineRowsSent" was received, but didn't have correct parameters.
It reports DTSER_SUCCESS(0).
But the package transfers all the data correctly and is writing any bad records off to text files for correction. Other than the lines above I am getting no errors. My latest
run had 97,000 lines of these messages.
The command entered is "dtexec /f "main.dtsx" /rep wd >ssislogs.txt"
Anyone have any idea why I am getting these errors or how to make them go away?
November 16th, 2012 9:59am
Maybe these are new diagnostic messages in which were introduced later.
Add "/REP E;Diagnostics" at the end of the command.
Free Windows Admin Tool Kit Click here and download it now
November 16th, 2012 11:07am
I am getting these errors as well using the D option for /REPORTS but the package still indicats success at the end DTSER_SUCCESS (0)
Calling syntax: dtexec.exe /DTS "MSDB\isExport_Reference" /SERVER MYServer /CHECKPOINTING OFF /REPORTING D
SQL Server 2012 Service Pack 1 is installed
OUTPUT:
Microsoft (R) SQL Server Execute Package Utility
Version 11.0.2100.60 for 32-bit
Copyright (C) Microsoft Corporation. All rights reserved.
Started: 10:28:05 AM
The event "OnPipelineRowsSent" was received, but didn't have correct parameters.
The event "OnPipelineRowsSent" was received, but didn't have correct parameters.
The event "OnPipelineRowsSent" was received, but didn't have correct parameters.
The event "OnPipelineRowsSent" was received, but didn't have correct parameters.
The event "OnPipelineRowsSent" was received, but didn't have correct parameters.
The event "OnPipelinePreEndOfRowset" was received, but didn't have correct param
eters.
The event "OnPipelineRowsSent" was received, but didn't have correct parameters.
The event "OnPipelineRowsSent" was received, but didn't have correct parameters.
The event "OnPipelineRowsSent" was received, but didn't have correct parameters.
The event "OnPipelineRowsSent" was received, but didn't have correct parameters.
The event "OnPipelinePreEndOfRowset" was received, but didn't have correct param
eters.
The event "OnPipelineRowsSent" was received, but didn't have correct parameters.
The event "OnPipelinePreEndOfRowset" was received, but didn't have correct param
eters.
The event "OnPipelineRowsSent" was received, but didn't have correct parameters.
The event "OnPipelinePreEndOfRowset" was received, but didn't have correct param
eters.
The event "OnPipelineRowsSent" was received, but didn't have correct parameters.
The event "OnPipelineRowsSent" was received, but didn't have correct parameters.
The event "OnPipelineRowsSent" was received, but didn't have correct parameters.
The event "OnPipelinePreEndOfRowset" was received, but didn't have correct param
eters.
The event "OnPipelineRowsSent" was received, but didn't have correct parameters.
The event "OnPipelineRowsSent" was received, but didn't have correct parameters.
The event "OnPipelinePreEndOfRowset" was received, but didn't have correct param
eters.
The event "OnPipelineRowsSent" was received, but didn't have correct parameters.
The event "OnPipelinePreEndOfRowset" was received, but didn't have correct param
eters.
The event "OnPipelineRowsSent" was received, but didn't have correct parameters.
The event "OnPipelineRowsSent" was received, but didn't have correct parameters.
The event "OnPipelinePreEndOfRowset" was received, but didn't have correct param
eters.
The event "OnPipelineRowsSent" was received, but didn't have correct parameters.
The event "OnPipelinePreEndOfRowset" was received, but didn't have correct param
eters.
The event "OnPipelineRowsSent" was received, but didn't have correct parameters.
The event "OnPipelinePreEndOfRowset" was received, but didn't have correct param
eters.
The event "OnPipelineRowsSent" was received, but didn't have correct parameters.
The event "OnPipelinePreEndOfRowset" was received, but didn't have correct param
eters.
The event "OnPipelineRowsSent" was received, but didn't have correct parameters.
The event "OnPipelinePreEndOfRowset" was received, but didn't have correct param
eters.
The event "OnPipelineRowsSent" was received, but didn't have correct parameters.
DTExec: The package execution returned DTSER_SUCCESS (0).
Started: 10:28:05 AM
Finished: 10:28:12 AM
Elapsed: 7.125 seconds
November 16th, 2012 11:30am
Thank you very much, that set me in the right direction. I played around with the parameters, it looks like the "p" parameter of the /REP option is the culprit. I was hoping that by adding the
"d" parameter to the /REP option it would list any errors that occurred in the data flow tasks, and it does - to excess.
Any idea why the data flow tasks are throwing the errors on "OnPipelinePreEndOfRowset"
and "OnPipelineRowsSent", yet transferring the data despite the errors? I haven't found any options to alter those events in the package. I think at this
point I am just going to start disabling portions of the package until it stops throwing those errors, then work from there.
Free Windows Admin Tool Kit Click here and download it now
November 16th, 2012 1:02pm


