Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 DTS Creation/Design Problem

Author  Topic 

TJ
Posting Yak Master

201 Posts

Posted - 2002-03-27 : 12:14:44
There are 3 people in the company that create DTS' for SQL Server 7.0.

Yesterday:
Two of us are able to see and redesign a DTS that the other one creates. The third person is unable to see ours and we are unable to access his. I checked the ODBC drivers and found that he was running SP1 while we had SP2.

Today:
His pc was updated to SP2. He is now able to see our DTS, but we still cannot see his. To test that perhaps it was because the older ones were created with different drivers, I created a new DTS from his pc and one on mine. I still get the same results.

Can anyone tell me what else I need to look for?

(I hope I'm in the right forum for this question!)

Thanks!
Teresa

"Someday I'll know enough to help someone else!"

Edited by - tj on 03/27/2002 12:16:50

TJ
Posting Yak Master

201 Posts

Posted - 2002-03-29 : 16:01:00
We've found that installing SP3 fixes the problem!

"Someday I'll know enough to help someone else!"
Go to Top of Page
   

- Advertisement -