Global Rowset empty for no apparent reason. | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Global Rowset empty for no apparent reason.

Hello. I have a DTS package that performs what I would think would be a simple task. It executes an sp using a Sql Task, storing the output into a global rowset. Then a script task runs that creates a pipe delimited text file using the rowset. The problem appears to be that, for some reason unkown to me, the rowset is empty when it shouldn’t be and the script file creates an empty text file since there isn’t any data to process. This situation appears to occur randomly. I have not been able to create a set of symptoms that cause it. Has anyone seen anything like this and can make some suggestions on how to address it? Any leads would be appreciated. Thanks in advance, Jerry