DTS Export/Import Wizards: Server 7.0 to Desktop 7.0 
Author Message
 DTS Export/Import Wizards: Server 7.0 to Desktop 7.0

I'm am able to use the DTS Export/Import Wizards from 5 of my production 7.0
servers to Desktop 7.0 without any problems. But I am unable to do this from
two production 7.0 server to Desktop 7.0. I get an error that reads "The
license for the installation of Microsoft SQL Server on you source and
destination connections does not permit the use DTS to transform data. Refer
to you license agreement for more information."

I presume that I have some setting on the server version that is not
allowing me to use the DTS Wizard with Desktop 7.0.

What setting do I need to change on the server?

Please advise.

Mike Mullane



Sat, 22 Nov 2003 23:28:55 GMT
 DTS Export/Import Wizards: Server 7.0 to Desktop 7.0



Quote:
>I'm am able to use the DTS Export/Import Wizards from 5 of my production 7.0
>servers to Desktop 7.0 without any problems. But I am unable to do this from
>two production 7.0 server to Desktop 7.0. I get an error that reads "The
>license for the installation of Microsoft SQL Server on you source and
>destination connections does not permit the use DTS to transform data. Refer
>to you license agreement for more information."

>I presume that I have some setting on the server version that is not
>allowing me to use the DTS Wizard with Desktop 7.0.

>What setting do I need to change on the server?

>Please advise.

>Mike Mullane

Mike, see-
http://support.microsoft.com/support/kb/articles/q207/8/09.asp

--
Darren Green
http://www.sqldts.com



Sun, 23 Nov 2003 02:43:27 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Importing text files into SQL Server 2000 Database using DTS Import/Export Wizard

2. dts error while importing or exporting a database between 2 SQL 7.0 Server

3. SQL SERVER 7.0 DTS (IMPORT/EXPORT)

4. DTS with SQL 7.0 Desktop and SQL 7.0 Enterprise

5. Exporting/Importing Objects from SQL 7.0 to SQL 7.0

6. Importing SAS dataset via DTS Import/Export Wizard

7. Access 2000 to SQL Server 2000 using Import/Export Wizard or DTS

8. DTS Wizard will not import/export between SQL Server Databases

9. importing a SQL Server 7.0 database to a SQL Server 7.0 database

10. Import and Export Wizard to transfer data and Objects from one SQL Server 7.0 Database to another SQL Server 7.0 Database

11. Importing and exporting data in sql server 7.0

12. Problem while importing/exporting data on SQL Server 7.0


 
Powered by phpBB® Forum Software