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

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 HolmesI 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
>
>

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 HolmesI 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
>
>

Docs files in FTDATA

Hi,
I have a SQL Server 2000 cluster, sp 3 in w2k.
When the catalog is reindexed, some documents appears in FTDATA folder. If I
delete the documents, then they reappear in the next indexing.
I'm thinking about to schedule a batch that cleanup this folder, because I
have the FTDATA in the Quorum drive, with no much free space.
Why this is? How can I avoid it?
qwalgrande
What do you mean by documents? Can you open these documents in Word or
notepad?
These documents will be extracted by the indexing process, but on my non
clustered system they are cleaned up.
Some files will remain which are used my mssearch to track where it is in
the indexing process. You shouldn't touch these files.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"qwalgrande" <qwalgrande*nospam*@.yahoo.es> wrote in message
news:6131ACD4-A717-48D6-AC63-4F2FE43B7CA5@.microsoft.com...
> Hi,
> I have a SQL Server 2000 cluster, sp 3 in w2k.
> When the catalog is reindexed, some documents appears in FTDATA folder. If
I
> delete the documents, then they reappear in the next indexing.
> I'm thinking about to schedule a batch that cleanup this folder, because I
> have the FTDATA in the Quorum drive, with no much free space.
> Why this is? How can I avoid it?
> --
> qwalgrande
|||one more point - exactly which subdirectory of ftdata do these files exist
in.
It could be possible that they are eithre configuration files or the actual
index/catalog files themselves.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:%238ZUxJKoEHA.2340@.TK2MSFTNGP11.phx.gbl...[vbcol=seagreen]
> What do you mean by documents? Can you open these documents in Word or
> notepad?
> These documents will be extracted by the indexing process, but on my non
> clustered system they are cleaned up.
> Some files will remain which are used my mssearch to track where it is in
> the indexing process. You shouldn't touch these files.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> "qwalgrande" <qwalgrande*nospam*@.yahoo.es> wrote in message
> news:6131ACD4-A717-48D6-AC63-4F2FE43B7CA5@.microsoft.com...
If[vbcol=seagreen]
> I
I
>
|||Hello, Hilary.
I will try to explain it better. These "documents" are the documents that I
had inserted in my indexed image column. In the population, the documents
"pass" for the folder and quickly disappear, but a few documents stay in the
folder and don't cleaned up.
The directory is FTDATA, no subdirectories. I have tried in a nonclustered
server too, whit the same result. Could you help me?
Thanks in advanced.
"Hilary Cotter" wrote:

> one more point - exactly which subdirectory of ftdata do these files exist
> in.
> It could be possible that they are eithre configuration files or the actual
> index/catalog files themselves.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:%238ZUxJKoEHA.2340@.TK2MSFTNGP11.phx.gbl...
> If
> I
>
>
|||qwalgrande,
The behavior you are seeing is by design, except for the document files not
being deleted, I *believe* has be acknowledged as a bug by Microsoft and may
(or may not) be fixed in the next Service Pack (SP4) for SQL Sever 2000.
This issue was discovered about a year ago on this newsgroup and the
non-delete of the files acknowledged as a bug by Microsoft, but alas we were
not provided with an actual bug number for tracking purposes. Hopefully,
this will be addressed in the next Service Pack (SP4) for SQL Sever 2000.
Regards,
John
"qwalgrande" <qwalgrande*nospam*@.yahoo.es> wrote in message
news:054B35B9-15F1-4BDF-A193-D03638EA71CC@.microsoft.com...
> Hello, Hilary.
> I will try to explain it better. These "documents" are the documents that
I
> had inserted in my indexed image column. In the population, the documents
> "pass" for the folder and quickly disappear, but a few documents stay in
the[vbcol=seagreen]
> folder and don't cleaned up.
> The directory is FTDATA, no subdirectories. I have tried in a nonclustered
> server too, whit the same result. Could you help me?
> Thanks in advanced.
> "Hilary Cotter" wrote:
exist[vbcol=seagreen]
actual[vbcol=seagreen]
non[vbcol=seagreen]
in[vbcol=seagreen]
folder.[vbcol=seagreen]
because[vbcol=seagreen]