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
 SQL Server Administration (2000)
 Upgrade Problems

Author  Topic 

drunkle
Starting Member

11 Posts

Posted - 2001-06-19 : 13:07:19
I've upgraded one of our servers from SQL 7.0 desktop edition to SQL 2000
Standard edition. After that was completed we then install SP1 for SQL 2000.
Now we are noticing problems using DTS. Today one of the users was trying to
setup a DTS package that would bring a text file into one of the database tables.
These problems are only manifested when logged directly onto the server. The DTS
Wizard for import of data gives an error DTS Import/Export Wizard Error:
CoCreateInstance. It then allows the wizard to be brought up but when trying to
select the text file source it is missing and so are a lot of other standard
drivers supplied by Microsoft. I'm thinking we have a MDAC issue on the server. Does anyone have suggestions or thoughts on this issue?
.

   

- Advertisement -