DTS Error

In trying to run a step in a DTS package, I get this error
on SQL 2000 running on Windows 2000.
"The DTS cannot copy or transform data from a desktop or
MSDE Server to a standard, Enterprise of small business
version of SQL SERVER unless your destination server is
per user licensing mode."
I thought the error was WIndows 2000 licensing error. The
licensing is set to per seat. Anyone know how I could
fixe this?
Mitch,
[vbcol=seagreen]
In the context of the error message, I think it refers to SQL2000 licensing
in the destination server.Can you post the output of the below commands on
both source and destination servers ?
SELECT SERVERPROPERTY('PRODUCTLEVEL')
SELECT SERVERPROPERTY('LICENSETYPE')
SELECT SERVERPROPERTY('EDITION')
Dinesh
SQL Server MVP
--
SQL Server FAQ at
http://www.tkdinesh.com
"Mitch Orndorff" <orndorffm@.hotmail.com> wrote in message
news:1845c01c44a77$e7328d30$a301280a@.phx.gbl...
> In trying to run a step in a DTS package, I get this error
> on SQL 2000 running on Windows 2000.
> "The DTS cannot copy or transform data from a desktop or
> MSDE Server to a standard, Enterprise of small business
> version of SQL SERVER unless your destination server is
> per user licensing mode."
> I thought the error was WIndows 2000 licensing error. The
> licensing is set to per seat. Anyone know how I could
> fixe this?
|||I work with Mitch Orndorff. Here is the results of the select
statements:
SELECT SERVERPROPERTY('PRODUCTLEVEL') SP3
SELECT SERVERPROPERTY('LICENSETYPE') DISABLED
SELECT SERVERPROPERTY('EDITION') Personal Edition
I checked the same on the server we are replacing, and the LICENSETYPE
is set to PER_SEAT. So, I understand we need to change the new server
to PER_SEAT licensing. The question is, how? (Please don't tell me a
reinstall). Thank you in advance for any help you can provide.
"Dinesh T.K" <tkdinesh@.nospam.mail.tkdinesh.com> wrote in message news:<#EK9vSCVEHA.3788@.TK2MSFTNGP12.phx.gbl>...[vbcol=seagreen]
> Mitch,
> In the context of the error message, I think it refers to SQL2000 licensing
> in the destination server.Can you post the output of the below commands on
> both source and destination servers ?
> SELECT SERVERPROPERTY('PRODUCTLEVEL')
> SELECT SERVERPROPERTY('LICENSETYPE')
> SELECT SERVERPROPERTY('EDITION')
> --
> Dinesh
> SQL Server MVP
> --
> --
> SQL Server FAQ at
> http://www.tkdinesh.com
> "Mitch Orndorff" <orndorffm@.hotmail.com> wrote in message
> news:1845c01c44a77$e7328d30$a301280a@.phx.gbl...
sql

DTS Error

In trying to run a step in a DTS package, I get this error
on SQL 2000 running on Windows 2000.
"The DTS cannot copy or transform data from a desktop or
MSDE Server to a standard, Enterprise of small business
version of SQL SERVER unless your destination server is
per user licensing mode."
I thought the error was Windows 2000 licensing error. The
licensing is set to per seat. Anyone know how I could
fixe this?Mitch,

In the context of the error message, I think it refers to SQL2000 licensing
in the destination server.Can you post the output of the below commands on
both source and destination servers ?
SELECT SERVERPROPERTY('PRODUCTLEVEL')
SELECT SERVERPROPERTY('LICENSETYPE')
SELECT SERVERPROPERTY('EDITION')
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"Mitch Orndorff" <orndorffm@.hotmail.com> wrote in message
news:1845c01c44a77$e7328d30$a301280a@.phx
.gbl...[vbcol=seagreen]
> In trying to run a step in a DTS package, I get this error
> on SQL 2000 running on Windows 2000.
> "The DTS cannot copy or transform data from a desktop or
> MSDE Server to a standard, Enterprise of small business
> version of SQL SERVER unless your destination server is
> per user licensing mode."
> I thought the error was Windows 2000 licensing error. The
> licensing is set to per seat. Anyone know how I could
> fixe this?|||I work with Mitch Orndorff. Here is the results of the select
statements:
SELECT SERVERPROPERTY('PRODUCTLEVEL') SP3
SELECT SERVERPROPERTY('LICENSETYPE') DISABLED
SELECT SERVERPROPERTY('EDITION') Personal Edition
I checked the same on the server we are replacing, and the LICENSETYPE
is set to PER_SEAT. So, I understand we need to change the new server
to PER_SEAT licensing. The question is, how? (Please don't tell me a
reinstall). Thank you in advance for any help you can provide.
"Dinesh T.K" <tkdinesh@.nospam.mail.tkdinesh.com> wrote in message news:<#EK9vSCVEHA.3788@.TK2
MSFTNGP12.phx.gbl>...[vbcol=seagreen]
> Mitch,
>
> In the context of the error message, I think it refers to SQL2000 licensin
g
> in the destination server.Can you post the output of the below commands on
> both source and destination servers ?
> SELECT SERVERPROPERTY('PRODUCTLEVEL')
> SELECT SERVERPROPERTY('LICENSETYPE')
> SELECT SERVERPROPERTY('EDITION')
> --
> Dinesh
> SQL Server MVP
> --
> --
> SQL Server FAQ at
> http://www.tkdinesh.com
> "Mitch Orndorff" <orndorffm@.hotmail.com> wrote in message
> news:1845c01c44a77$e7328d30$a301280a@.phx
.gbl...

DTS Error

In trying to run a step in a DTS package, I get this error
on SQL 2000 running on Windows 2000.
"The DTS cannot copy or transform data from a desktop or
MSDE Server to a standard, Enterprise of small business
version of SQL SERVER unless your destination server is
per user licensing mode."
I thought the error was WIndows 2000 licensing error. The
licensing is set to per seat. Anyone know how I could
fixe this?Mitch,
>> I thought the error was WIndows 2000 licensing error.
In the context of the error message, I think it refers to SQL2000 licensing
in the destination server.Can you post the output of the below commands on
both source and destination servers ?
SELECT SERVERPROPERTY('PRODUCTLEVEL')
SELECT SERVERPROPERTY('LICENSETYPE')
SELECT SERVERPROPERTY('EDITION')
--
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"Mitch Orndorff" <orndorffm@.hotmail.com> wrote in message
news:1845c01c44a77$e7328d30$a301280a@.phx.gbl...
> In trying to run a step in a DTS package, I get this error
> on SQL 2000 running on Windows 2000.
> "The DTS cannot copy or transform data from a desktop or
> MSDE Server to a standard, Enterprise of small business
> version of SQL SERVER unless your destination server is
> per user licensing mode."
> I thought the error was WIndows 2000 licensing error. The
> licensing is set to per seat. Anyone know how I could
> fixe this?|||I work with Mitch Orndorff. Here is the results of the select
statements:
SELECT SERVERPROPERTY('PRODUCTLEVEL') SP3
SELECT SERVERPROPERTY('LICENSETYPE') DISABLED
SELECT SERVERPROPERTY('EDITION') Personal Edition
I checked the same on the server we are replacing, and the LICENSETYPE
is set to PER_SEAT. So, I understand we need to change the new server
to PER_SEAT licensing. The question is, how? (Please don't tell me a
reinstall). Thank you in advance for any help you can provide.
"Dinesh T.K" <tkdinesh@.nospam.mail.tkdinesh.com> wrote in message news:<#EK9vSCVEHA.3788@.TK2MSFTNGP12.phx.gbl>...
> Mitch,
> >> I thought the error was WIndows 2000 licensing error.
> In the context of the error message, I think it refers to SQL2000 licensing
> in the destination server.Can you post the output of the below commands on
> both source and destination servers ?
> SELECT SERVERPROPERTY('PRODUCTLEVEL')
> SELECT SERVERPROPERTY('LICENSETYPE')
> SELECT SERVERPROPERTY('EDITION')
> --
> Dinesh
> SQL Server MVP
> --
> --
> SQL Server FAQ at
> http://www.tkdinesh.com
> "Mitch Orndorff" <orndorffm@.hotmail.com> wrote in message
> news:1845c01c44a77$e7328d30$a301280a@.phx.gbl...
> > In trying to run a step in a DTS package, I get this error
> > on SQL 2000 running on Windows 2000.
> >
> > "The DTS cannot copy or transform data from a desktop or
> > MSDE Server to a standard, Enterprise of small business
> > version of SQL SERVER unless your destination server is
> > per user licensing mode."
> >
> > I thought the error was WIndows 2000 licensing error. The
> > licensing is set to per seat. Anyone know how I could
> > fixe this?

DTS Creation issue

Hi all,

Here is the problem : I can not create a DTS package in SQLServer.
=> Error description : access denied
Environment :
- Windows NT4 sp6 Server, french, logon on as "Administrator".
- SQLServer 7.0 sp4, french, logon as "sa" on the NT Server with Enterprise Manager.
- SQLServer Agent runs under an Administrator account

Why can't i create single DTS package ? Strange, isn't it ?
Many thanks for your ideas

BertrandLook for the latest Service Pack (I don't know the exact one but I think it's 3)

Good luck.|||Actually it is the french sp4 for SQLServer 7.0 french.

I can design a DTS package but i can not save it : "Access denied".
Thanks for your help

Originally posted by Crespo-n00b
Look for the latest Service Pack (I don't know the exact one but I think it's 3)

Good luck.|||On SQL ver7 SP4 is the last and latest despite of language.

Can you try creating DTS package using DTS wizard.

DTS and "SQL Server does not exist or access denied"

I recently had a problem with a process that had been working, well, forever
.
The process starts a DTS package step (SQL Server 2000, Windows Server 2003
on both machines; both machines are in the same domain, behind our firewall)
that copies records from one server to another. For some reason, it returned
the "SQL Server does not exist or access denied" error. The problem started
abruptly on Dec 8, 2005.
I noticed after a while that the the process always died after the same
number of records, 3950 +- 3. On a whim, just for kicks, I went into debug
and ran the VB6 program that creates the DTS package and set the
InsertCommitSize to 100 (it had been zero), and this cleared up the error.
My questions are:
1) Has anyone else run into this?
2) It looks like something out there didn't like the size of the buffer I
sent to it. Does anyone know why?
3) Does the size of the BLOB have anything to do with this?
I'd appreciate any response I can get from anyone else who has run into
this, and what they may have done to fix it when they got it.hi Mike,
How odd! I've got about 600 dts running on day-to-day basis and neither of
them own that property to 100, always own zero. I experienced problems with
'Copy objects' task when source database own field with data type as 'text',
for example.
--
current location: alicante (es)
"MikeM in Sac" wrote:

> I recently had a problem with a process that had been working, well, forev
er.
> The process starts a DTS package step (SQL Server 2000, Windows Server 200
3
> on both machines; both machines are in the same domain, behind our firewal
l)
> that copies records from one server to another. For some reason, it return
ed
> the "SQL Server does not exist or access denied" error. The problem starte
d
> abruptly on Dec 8, 2005.
> I noticed after a while that the the process always died after the same
> number of records, 3950 +- 3. On a whim, just for kicks, I went into debug
> and ran the VB6 program that creates the DTS package and set the
> InsertCommitSize to 100 (it had been zero), and this cleared up the error.
> My questions are:
> 1) Has anyone else run into this?
> 2) It looks like something out there didn't like the size of the buffer I
> sent to it. Does anyone know why?
> 3) Does the size of the BLOB have anything to do with this?
> I'd appreciate any response I can get from anyone else who has run into
> this, and what they may have done to fix it when they got it.

DTRUN command

Hi.
I have a sql job that is failing, while looking why the job failed, In the
preperty Step- tab /command windows: has DTSRun /~ this long address
following .
I just started this gig and I'm not sure what is being called. how can I
found out what procedure or process this job was calling by looking at the
address?
Thanks in advance.Correction: the command is DTSRUN
"ITDUDE27" wrote:
> Hi.
> I have a sql job that is failing, while looking why the job failed, In the
> preperty Step- tab /command windows: has DTSRun /~ this long address
> following .
> I just started this gig and I'm not sure what is being called. how can I
> found out what procedure or process this job was calling by looking at the
> address?
> Thanks in advance.|||The DTS package scheduling wizard encrypts DTSRUN parameters. You can see
the package name retrieved from msdb by using SQL Profiler while DTSRUN is
executed. There are also cracks for the DTSRUN parameters you can find on
the web.
IMHO, it's better to code DTSRUN parameters in clear text unless you have a
reason to do otherwise.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"ITDUDE27" <ITDUDE27@.discussions.microsoft.com> wrote in message
news:E8CB6912-5819-4F0F-A81E-5C770AA163FD@.microsoft.com...
> Hi.
> I have a sql job that is failing, while looking why the job failed, In
> the
> preperty Step- tab /command windows: has DTSRun /~ this long address
> following .
> I just started this gig and I'm not sure what is being called. how can I
> found out what procedure or process this job was calling by looking at the
> address?
> Thanks in advance.

DTRUN command

Hi.
I have a sql job that is failing, while looking why the job failed, In the
preperty Step- tab /command windows: has DTSRun /~ this long address
following .
I just started this gig and I'm not sure what is being called. how can I
found out what procedure or process this job was calling by looking at the
address?
Thanks in advance.The DTS package scheduling wizard encrypts DTSRUN parameters. You can see
the package name retrieved from msdb by using SQL Profiler while DTSRUN is
executed. There are also cracks for the DTSRUN parameters you can find on
the web.
IMHO, it's better to code DTSRUN parameters in clear text unless you have a
reason to do otherwise.
Hope this helps.
Dan Guzman
SQL Server MVP
"ITDUDE27" <ITDUDE27@.discussions.microsoft.com> wrote in message
news:E8CB6912-5819-4F0F-A81E-5C770AA163FD@.microsoft.com...
> Hi.
> I have a sql job that is failing, while looking why the job failed, In
> the
> preperty Step- tab /command windows: has DTSRun /~ this long address
> following .
> I just started this gig and I'm not sure what is being called. how can I
> found out what procedure or process this job was calling by looking at the
> address?
> Thanks in advance.

dtexec Return Success BUT Not Run!

I've created a Maintenance Plan in Microsoft SQL Server Management Studio (Sql Server 2005 SP2 + Windows Updates) and currently trying to execute it via the dtexec command line program.

The problem is that it reports that it executed the Maintenance Plan but it never actually executes the Plan. The data isn't updated and the CPU and hard drive I/O reports nothing happening.

I've checked the argument lists but I don't think I've missed anything...?

On the Sql Machine itself, I run the command line as follows:
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
Microsoft Windows [Version 5.2.3790]
(C) Copyright 1985-2003 Microsoft Corp.

C:\Documents and Settings\V2Admin>cd \
C:\>dtexec /SQL "\Maintenance Plans\GPI Update" /Server V2SQL\VC2 /User sa /Pass
word XxXxXxX
Microsoft (R) SQL Server Execute Package Utility
Version 9.00.3042.00 for 32-bit
Copyright (C) Microsoft Corp 1984-2005. All rights reserved.

Started: 11:29:43 AM
DTExec: The package execution returned DTSER_SUCCESS (0).
Started: 11:29:43 AM
Finished: 11:29:44 AM
Elapsed: 0.375 seconds

C:\>
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>I don't understand why you are running using DTEXEC, have you tried to schedule the package that is created using SSIS?|||We are running DTExec as we want chain together and run other processes outside as Sql Server as well, but want to use the History tracker of Sql Server's Maintenance Plans.

The Sql Server Maintenance Plan tasks are kept with Sql Server and the external processes are kept with their relevant tools.

We need to run both together which is why we need to call DtExec.

At the worst case scenario, we can simply run SqlCmd and execute the desired functionality, but that is asking for problems as there would then be two locations to maintain the Maintenance Tasks Sub-Plans.

Not a smart move in any operations manual!
|||

Schedule a maintenance plan and look at the arguments to dtexec in the agent job step. You will find that the subplan that contains your job steps is enabled from that command line. If you just run a maintenance plan without so enabling the subplans, all are disabled, and nothing runs, as you have confirmed in your scenario.

jkh

dtexec

I have saved a copy of a package to a 64-bit server running Windows 2003 Enterprise Edition SP1. I changed the Run64BitRuntime to true before saving the package. When I try to use DTExec to execute the package which does have a script task in it I receive the below error.

Error: 2005-08-17 16:52:32.89
Code: 0x00000005
Source: Script Task 1
Description: The script files failed to load.
End Error

Any help is appreciated.

Thanks.In your script task set PreCompileScriptIntobinaryCode=TRUE

This is a known issue with 64-bit machines. The default setting for this property (as of the next CTP) has been set to TRUE because of it.

-Jamie|||Jamie is correct that the default value of this property has been changed from False to True. The Integration Services team opted for 64-bit convenience at the cost of increased package size. 32-bit users may want to measure the impact of this setting if package size is ever a concern.

-Doug|||Thanks you guys - I have been able to get the packages scheduled.

DTC restart shutdown SQL server, why?

SQL 2000 SP4 standard on Windows 2003 Enterprise.

On Friday our DTC service restarted on a couple of servers (we think cause of a config change made by the network guys) but on one server it also shutdown the sql server... We cannot find anything that indicates why. I have looked and cannot find any reason why SQL would be a require DTC to be running expecially since none of the other servers shut down.

The only difference in this one server as compared to the others is it is a publisher for merge replication and the other servers are either a subscriber or publisher of transactional. Would this have anything to do with it?

Also is SQL actually dependant on DTC for any reason that would cause it to be shutdown when DTC is restarted?

A down MSDTC shouldn't cause your sqlserver to stop running. There must be something else in the loop. What can you find in sql logs (i.e. errorlog.*).

DTC Problems on SQL 2000/Windows Server 2003

I have an ASP application that is working on IIS 4.0/NT 4.0 and SQL Server 7.0/NT 4.0. The ASP pages are using a package registered in the MTS 2.0 running on the IIS server.

I am starting to move my databases over to a new server running SQL Server 2000 on Windows Server 2003.

When I change the database server name in the connection string on the ASP pages and then attempt to run that page I get:

Microsoft OLE DB Provider for SQL Server error '8004d00a'

New transaction cannot enlist in the specified transaction coordinator.

I have confirmed that the Distributed Transaction Controller is running on my new SQL Server box and I have confirmed that network DTC access is on. If I stop the DTC service on my new SQL Server, the error message indicates that the DTC is not running.

Now I am stuck. Any ideas would be greatly appreciated.

Jeff BanningPlease check out Q329332 for help.

Sarah