DTS Problem

[paragvshah]

Hi friends,

This is the error we receive when we attempt to upload our offline tables onto our online server.

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


What and where could be the problem

Parag.

 

[tlbroadbent]

Which version of SQL Server and which editions? You cannot do DTS transformtions between desktop and server editions of SQL Server 7 without per seat licensing.

Check this KB article.

INF: DTS/Replication Licensing for Desktop SQL Server 7.0

http://support.microsoft.com/support/kb/articles/Q207/8/09.ASP

Terry
------------------------------------
Blessed is the man who, having nothing to say, abstains from giving us worthy evidence of the fact. -George Eliot