Hello Guarddata:

You are dead-on regarding both points. I've never worked with the Query Analyzer Execution Plans before, but I used it last night to come to the same conclusion you...

Hi:

Sorry. The line

'If intTestChoice = 2 Then'

should be

'If intTestChoice = 1 Then'

Also, there are two functions that return a recordset based on the value of intTestChoice

GetContactDBData

vs

GetContactDBDataTest

That's why there...

Hello Guarddata:

Well, I went back to the drawing board and set up a test case:

intTestChoice = 1 ' use separate database connections/queries

intTestChoice = 2 ' use single databases connection...

I thought so too, but my experience is limited. I'll go back and take another look at it.

Thanks,

JK

I thought so too, but my experience is limited. I'll go back and take another look at it.

Thanks,

JK

Hi:

It looks like I found the answer. I developed the package on a machine with 2.7. I'll check to see what version is on the target machine.

Microsoft Knowledge Base Article...

Hello Andy:

Thank you. I had a feeling that was the case.

Thank you again.

JK

Hi:

I installed SQL Server 7.0 Service pack 4 and I can now access the DTS package from the machine it was developed on.

Thanks,

JK

Hi:

Additional information:

If I run

SELECT * FROM sysdtspackages

in the msdb database

I see the two DTS packages, only one I care about. The fields are all populated and the data looks...

Hi:

I've finally took time to revisit this situation yesterday. With your help, I was able to work it out, but I do have one additional question (at the end of...

Thanks guys. I appreciate the help. I did some reading about query optimization (fund covering indexes there) last night, and found SHOWPLAN, so I have some work do, but I've...

Hi:

Thanks for taking the time to go into so much detail.

Q1 Response:

There is no indication of any kind from Query Analyzer aside from the Exec time continuing to increment....

Hi:

OK, thanks. I've looked for documentation on the OpenDataSource function in Books Online a few more times using different approaches and just haven't found anything. I currently use ADO...

Hi:

Thanks for the information.

Question: Is OpenDataSource a SQL Server 2000 function, or is that also in SQL Server 7.0? I'm running 7.0, I looked in Books Online for that...

Hi everyone:

OK, I understand. I wasn't successful with the .NextRecordset workaround because I didn't take it far enough. I used the .NextRecordset method only once. If I loop it until...