DTS issue with Cursor fetch status

[xaq98]

I have a DTS package with several transformation steps and execute SQL steps. If I run the package one step at a time it runs fine. If I run it as a package one of the Execute SQL steps with a cursor runs differently. I inserted the fetch status from this step into a table and found it was starting off with a fetch status of -1 so the cursor would end with no data being processed. If I run the step manually, it processes all the records. All the steps in the package run sequentially. Plus the step in question only has one cursor in it. This step is set to Commit on completion of the step. Why does the package run differently if run as a whole verses running each step individually.