Import Or Export data

Import Or Export data

Post by Adi Doro » Mon, 18 Jun 2001 15:16:10



Dear Friend,

When i'm tring to Import Or Export data from the Databse between two
deffrent SQL Database I Get This Error :

The license for the installation of Microsoft SQL Server on your
source and destination connections does not permit the use DTS to
transform data.
Refer to your license agreement for more information.

Can you Help Me
Or Guide Me To solve this Problem

Kind regards,
Adi Doron


 
 
 

Import Or Export data

Post by Intermedia.NE » Mon, 18 Jun 2001 21:42:24


Hello!

Here's a possible problem: to use DTS you must have the full installation of
SQL server. The desktop edition is not enough.

--
=========================================
Intermedia.NET (APP)
Microsoft Certified Solutions Provider
Providing expertise in hosting applications
More Tips at:  http://www.intermedia.net/support/kb/
Windows 2000 Web Hosting:  http://www.intermedia.net/
For a waiver of the set up fee use "IMFREE" code
=========================================


> Dear Friend,

> When i'm tring to Import Or Export data from the Databse between two
> deffrent SQL Database I Get This Error :

> The license for the installation of Microsoft SQL Server on your
> source and destination connections does not permit the use DTS to
> transform data.
> Refer to your license agreement for more information.

> Can you Help Me
> Or Guide Me To solve this Problem

> Kind regards,
> Adi Doron




 
 
 

1. Importing and exporting data in sql server 7.0

I can't import or export data from/to file to table.  I create a table and
then when I want to import data to it using data transformation services
import wizard, it takes me all the way thru to the finish and then freezes
up when I click on finish.  I then have to end the task.  The same thing
happens if I try to export data.  I am not a dbo, but it seems I shouldn't
have to be if I can create a table and have insert, update and delete
priveleges.  I am a programmer not a dba (obviously).

--
Posted via CNET Help.com
http://www.help.com/

2. ADO and the Data Environment (VB6 EE)

3. Import and Export Data file into SQL6.5

4. Needed DBMS Kernel Developers

5. Import And Export Data

6. VB4en16.dll

7. sql import and export data problem

8. Problem locking tables using ODBC

9. SQL 7.0 Install on W98 - cannot import or export data

10. regarding Import and Export data

11. Import And Export Data

12. import and export data

13. SQL crashes when importing and exporting data