SQL Server Performance

Global Rowset empty for no apparent reason.

Discussion in 'SQL Server DTS-Related Questions' started by jdiegeliv, Jun 27, 2005.

  1. jdiegeliv New Member

    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

Share This Page