Wednesday, March 21, 2012

Does not permit the use of DTS

Apologies if this appears as a double post but my original news server does
not seem to be populating all groups.
I am trying to move some data from a sol 7 server to a sol 2000 server using
the export data wizard. The problem I am having is that after I enter both
the servers and step to the next step I get the message
"The licence for the installation of SQL server on your source and
destination connections does not permit the use of DTS to transform data.
See your licence agreement for more information"
The problem would seem to be on the 2000 server as the 7 will send data to
another server.
Paul Holmes
I think the personal editions didn't allow DTS... Try using BCP directly.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Colin" <NoSpam@.gmail.com> wrote in message
news:10msb7a360c84f5@.corp.supernews.com...
> Apologies if this appears as a double post but my original news server
does
> not seem to be populating all groups.
> I am trying to move some data from a sol 7 server to a sol 2000 server
using
> the export data wizard. The problem I am having is that after I enter both
> the servers and step to the next step I get the message
> "The licence for the installation of SQL server on your source and
> destination connections does not permit the use of DTS to transform data.
> See your licence agreement for more information"
> The problem would seem to be on the 2000 server as the 7 will send data to
> another server.
>
>
> Paul Holmes
>
>
sql

No comments:

Post a Comment