FTP Task Send error

I cannot seem to get the FTP task to send files. I tested the process manually (not using ssis) and it works fine. I have tried many ways to transfer the files, using variables, including full paths, partial paths, etc. but I keep getting a "550 permission denied" error. I have rechecked all variables. Has anybody else had trouble sending files with the FTP task?

Do you have access (or can someone GET access) to the FTP logs on the server to see who it thinks you are connecting as?|||

I am checking with them but it seems strange. I have set the user and password using a configuration file and I am getting the following error:

[Connection manager "MyFTPConnection"] Error: An error occurred in the requested FTP operation. Detailed error description: 200 Type set to IMAGE. 227 Entering Passive Mode (xx,xx,xxx,xxx,xx,xx). 550 permission denied .

I have tested the configuration file to make sure the server name was being set correctly from the file and it was. I am assuming the password would be also. I can connect manually.

This really should not be such a struggle. I remember DTS did not have an upload FTP component. Maybe I need a 3rd party component. Does anybody know of one?

|||

Looks like I'm connecting but the required slash is causing a permissions problem on the server. Anybody know how to solve this? The task won't let me send a file without a slash.

[FTP Task] Error: Variable "RemoteFile" doesn't start with "/".

sql

FTP Task Failure

We are unable to get a file from a VMS FTP site. The specific error message is:

[ftp task] Error: File represented by "/VEQFFP.TR.MTSS.RATE" does not exist.

normal command line ftp and other ftp tools all succeed. Is anyone else experiencing this difficultly?

Thx in advance.Hello

Had problems with the FTP task opening more than one connection (this was ) to the server. Workaround was to use cmd ftp taking input from file. That was best practice at the time.||| Have already used cmd files to accomplish this task. Want to use the new SQL FTP 2005 dtsx task. Since the Mainframe Server sets us into the root, I have not way to manuever to the directory to capture the file I need. Thx|||

Hi.

We are having the same problem.

Usually you don't need the "/" however SSIS is forcing you to put a "/" or it won't execute.

Have you found a workaround yet

Thank

|||I have the same problem which prevents pulling files off VMS. Even if I use an account that lands me in the correct directory upon connection, VMS won't accept the leading "/" that the SSIS FTP Task forces you to use. I'm thinking of using a Script Task to create my own FTP task (using the FtpWebRequest class from .NET 2.0), as the standard one simply isn't flexible enough.
|||I got the same error but it turned out that after browsing to the file to be downloaded using remote path, when I ran the task a configuration file was setting the ftp connection to a different server and then I received an error that the file did not exist.

FTP Task Failure

We are unable to get a file from a VMS FTP site. The specific error message is:

[ftp task] Error: File represented by "/VEQFFP.TR.MTSS.RATE" does not exist.

normal command line ftp and other ftp tools all succeed. Is anyone else experiencing this difficultly?

Thx in advance.Hello

Had problems with the FTP task opening more than one connection (this was ) to the server. Workaround was to use cmd ftp taking input from file. That was best practice at the time.||| Have already used cmd files to accomplish this task. Want to use the new SQL FTP 2005 dtsx task. Since the Mainframe Server sets us into the root, I have not way to manuever to the directory to capture the file I need. Thx|||

Hi.

We are having the same problem.

Usually you don't need the "/" however SSIS is forcing you to put a "/" or it won't execute.

Have you found a workaround yet

Thank

|||I have the same problem which prevents pulling files off VMS. Even if I use an account that lands me in the correct directory upon connection, VMS won't accept the leading "/" that the SSIS FTP Task forces you to use. I'm thinking of using a Script Task to create my own FTP task (using the FtpWebRequest class from .NET 2.0), as the standard one simply isn't flexible enough.
|||I got the same error but it turned out that after browsing to the file to be downloaded using remote path, when I ran the task a configuration file was setting the ftp connection to a different server and then I received an error that the file did not exist.sql

FTP Task Failure

We are unable to get a file from a VMS FTP site. The specific error message is:

[ftp task] Error: File represented by "/VEQFFP.TR.MTSS.RATE" does not exist.

normal command line ftp and other ftp tools all succeed. Is anyone else experiencing this difficultly?

Thx in advance.Hello

Had problems with the FTP task opening more than one connection (this was ) to the server. Workaround was to use cmd ftp taking input from file. That was best practice at the time.||| Have already used cmd files to accomplish this task. Want to use the new SQL FTP 2005 dtsx task. Since the Mainframe Server sets us into the root, I have not way to manuever to the directory to capture the file I need. Thx|||

Hi.

We are having the same problem.

Usually you don't need the "/" however SSIS is forcing you to put a "/" or it won't execute.

Have you found a workaround yet

Thank

|||I have the same problem which prevents pulling files off VMS. Even if I use an account that lands me in the correct directory upon connection, VMS won't accept the leading "/" that the SSIS FTP Task forces you to use. I'm thinking of using a Script Task to create my own FTP task (using the FtpWebRequest class from .NET 2.0), as the standard one simply isn't flexible enough.
|||I got the same error but it turned out that after browsing to the file to be downloaded using remote path, when I ran the task a configuration file was setting the ftp connection to a different server and then I received an error that the file did not exist.

FTP Task error when no files found on FTP

Hi,

I have created a FTP task that logs into FTP server and receives files and scheduled it to run every 15min. However, it fails when there are no files on FTP. How would I check the if files exist? How can I catch the FTP task error and compare it to Hresults.NoFilesFound in a script task?

Thanks in advance for any help.

Here is a package that uses the WMI DataReader task to check a folder for files (Thanks Kirk).

Change the FOLDERTOLOOKIN variable to tell it what the folder name is, eg -> FilesDrop\\NewFiles

Change the DRIVETOLOOKIN variable to tell it what drive you're on, eg -> C:

The package uses a script task to show the fully qualified names of the files in the given folder.

The package outputs the names of the files to the FILESINFOLDER variable.

You can use a variety of ways to determine if the files are there.

This package does uses an expression on the precedence constraint to determine if the length of list of file names is greater than 0.

The script task only executes if there are files in the folder you specify. There is no mandatory script in this package. Only demo script to show a message box.

I'm not able to enclose the package so pasted it inline.

<save the following into a new package (.dtsx) >

<?xml version="1.0"?><DTS:Executable xmlns:DTS="www.microsoft.com/SqlServer/Dts" DTS:ExecutableType="MSDTS.Package.1"><DTS:Property DTS:Name="PackageFormatVersion">2</DTS:Property><DTS:Property DTS:Name="VersionComments"></DTS:Property><DTS:Property DTS:Name="CreatorName">DIGITALDARKROOM\Kirk</DTS:Property><DTS:Property DTS:Name="CreatorComputerName">DIGITALDARKROOM</DTS:Property><DTS:Property DTS:Name="CreationDate" DTS:DataType="7">8/24/2005 2:31:04 PM</DTS:Property><DTS:Property DTS:Name="PackageType">5</DTS:Property><DTS:Property DTS:Name="ProtectionLevel">1</DTS:Property><DTS:Property DTS:Name="MaxConcurrentExecutables">-1</DTS:Property><DTS:Property DTS:Name="PackagePriorityClass">0</DTS:Property><DTS:Property DTS:Name="VersionMajor">1</DTS:Property><DTS:Property DTS:Name="VersionMinor">0</DTS:Property><DTS:Property DTS:Name="VersionBuild">5</DTS:Property><DTS:Property DTS:Name="VersionGUID">{48AF8158-4E9E-4541-A6AB-021099D0FE8A}</DTS:Property><DTS:Property DTS:Name="EnableConfig">0</DTS:Property><DTS:Property DTS:Name="CheckpointFileName"></DTS:Property><DTS:Property DTS:Name="SaveCheckpoints">0</DTS:Property><DTS:Property DTS:Name="CheckpointUsage">0</DTS:Property><DTS:Property DTS:Name="SuppressConfigurationWarnings">0</DTS:Property>
<DTS:ConnectionManager><DTS:Property DTS:Name="ObjectName">WMI Connection Manager</DTS:Property><DTS:Property DTS:Name="DTSID">{9f10cc24-7919-4cec-85a0-cde454c7598d}</DTS:Property><DTS:Property DTS:Name="Description">Connect to the local machine</DTS:Property><DTS:Property DTS:Name="CreationName">WMI</DTS:Property><DTS:ObjectData><WmiConnectionManager ConnectionString="ServerName=\\localhost;Namespace=\root\cimv2;UseNtAuth=True;UserName=;"><PassWord Sensitive="1" Encrypted="1">AQAAANCMnd8BFdERjHoAwE/Cl+sBAAAAqOymPn/hnk6nIeKlG26CGwAAAAAIAAAARABUAFMAAAADZgAAqAAAABAAAADf2RDrYmm04gJhrINpTzv0AAAAAASAAACgAAAAEAAAANKvr+kiwtHe1Gytu3jMIn4IAAAANMWO/krUx8MUAAAA5pODGqAD7RkcBRU1wcntq02Ne74&lt;</PassWord></WmiConnectionManager></DTS:ObjectData></DTS:ConnectionManager>
<DTS:PackageVariable><DTS:Property DTS:Name="PackageVariableValue" DTS:DataType="8">&lt;Package xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:dwd="http://schemas.microsoft.com/DataWarehouse/Designer/1.0"&gt;&lt;dwd:DtsControlFlowDiagram&gt;&lt;dwd:BoundingTop&gt;2646&lt;/dwd:BoundingTop&gt;&lt;dwd:Layout&gt;&lt;dds&gt;
&lt;diagram fontclsid="{0BE35203-8F91-11CE-9DE3-00AA004BB851}" mouseiconclsid="{0BE35204-8F91-11CE-9DE3-00AA004BB851}" defaultlayout="Microsoft.DataWarehouse.Layout.GraphLayout" defaultlineroute="Microsoft.DataWarehouse.Layout.GraphLayout" version="7" nextobject="6" scale="100" pagebreakanchorx="0" pagebreakanchory="0" pagebreaksizex="0" pagebreaksizey="0" scrollleft="0" scrolltop="0" gridx="150" gridy="150" marginx="1000" marginy="1000" zoom="100" x="19209" y="13467" backcolor="15334399" defaultpersistence="2" PrintPageNumbersMode="3" PrintMarginTop="0" PrintMarginBottom="635" PrintMarginLeft="0" PrintMarginRight="0" marqueeselectionmode="1" mousepointer="0" snaptogrid="0" autotypeannotation="1" showscrollbars="0" viewpagebreaks="0" donotforceconnectorsbehindshapes="1" backpictureclsid="{00000000-0000-0000-0000-000000000000}"&gt;
&lt;font&gt;
&lt;ddsxmlobjectstreamwrapper binary="01000000bc02803801000756657264616e61" /&gt;
&lt;/font&gt;
&lt;mouseicon&gt;
&lt;ddsxmlobjectstreamwrapper binary="6c74000000000000" /&gt;
&lt;/mouseicon&gt;
&lt;/diagram&gt;
&lt;layoutmanager&gt;
&lt;ddsxmlobj /&gt;
&lt;/layoutmanager&gt;
&lt;ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.1" tooltip="WMI Data Reader Task" left="2910" top="2646" logicalid="3" controlid="3" masterid="0" hint1="0" hint2="0" width="3598" height="1164" noresize="0" nomove="0" nodefaultattachpoints="0" autodrag="1" usedefaultiddshape="1" selectable="1" showselectionhandles="1" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0"&gt;
&lt;control&gt;
&lt;ddsxmlobjectstreaminitwrapper binary="000800000e0e00008c040000" /&gt;
&lt;/control&gt;
&lt;layoutobject&gt;
&lt;ddsxmlobj&gt;
&lt;property name="LogicalObject" value="{14485c88-8b76-4591-86b2-5ed365bf4fff}" vartype="8" /&gt;
&lt;property name="ShowConnectorSource" value="0" vartype="2" /&gt;
&lt;/ddsxmlobj&gt;
&lt;/layoutobject&gt;
&lt;shape groupshapeid="0" groupnode="0" /&gt;
&lt;/ddscontrol&gt;
&lt;ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.1" tooltip="Script Task" left="2934" top="5651" logicalid="4" controlid="4" masterid="0" hint1="0" hint2="0" width="4868" height="1164" noresize="0" nomove="0" nodefaultattachpoints="0" autodrag="1" usedefaultiddshape="1" selectable="1" showselectionhandles="1" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0"&gt;
&lt;control&gt;
&lt;ddsxmlobjectstreaminitwrapper binary="00080000041300008c040000" /&gt;
&lt;/control&gt;
&lt;layoutobject&gt;
&lt;ddsxmlobj&gt;
&lt;property name="LogicalObject" value="{933205d3-faf5-4a35-813a-c691178d0523}" vartype="8" /&gt;
&lt;property name="ShowConnectorSource" value="0" vartype="2" /&gt;
&lt;/ddsxmlobj&gt;
&lt;/layoutobject&gt;
&lt;shape groupshapeid="0" groupnode="0" /&gt;
&lt;/ddscontrol&gt;
&lt;ddscontrol controlprogid="MSDDS.Polyline" left="4310" top="3411" logicalid="5" controlid="5" masterid="0" hint1="0" hint2="0" width="1458" height="2740" noresize="0" nomove="0" nodefaultattachpoints="1" autodrag="0" usedefaultiddshape="0" selectable="1" showselectionhandles="0" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0"&gt;
&lt;control&gt;
&lt;ddsxmlobj&gt;
&lt;polyline endtypedst="3" endtypesrc="1" usercolor="32768" linestyle="0" linerender="2" customendtypedstid="0" customendtypesrcid="0" adornsvisible="1" /&gt;
&lt;/ddsxmlobj&gt;
&lt;/control&gt;
&lt;layoutobject&gt;
&lt;ddsxmlobj&gt;
&lt;property name="LogicalObject" value="{e446313d-d87f-48a3-b358-c9a2df9d032e}" vartype="8" /&gt;
&lt;property name="Virtual" value="0" vartype="11" /&gt;
&lt;property name="VisibleAP" value="0" vartype="3" /&gt;
&lt;/ddsxmlobj&gt;
&lt;/layoutobject&gt;
&lt;connector sourceid="3" destid="4" sourceattachpoint="7" destattachpoint="8" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0"&gt;
&lt;point x="4709" y="3810" /&gt;
&lt;point x="4709" y="4730" /&gt;
&lt;point x="5368" y="4730" /&gt;
&lt;point x="5368" y="5651" /&gt;
&lt;/connector&gt;
&lt;/ddscontrol&gt;
&lt;/dds&gt;&lt;/dwd:Layout&gt;&lt;/dwd:DtsControlFlowDiagram&gt;&lt;/Package&gt;</DTS:Property><DTS:Property DTS:Name="Namespace">dts-designer-1.0</DTS:Property><DTS:Property DTS:Name="ObjectName">{586389B6-EA85-4C59-A7DA-240197FDAF89}</DTS:Property><DTS:Property DTS:Name="DTSID">{575D6A04-5089-4C0F-9C60-0AA14F70540A}</DTS:Property><DTS:Property DTS:Name="Description"></DTS:Property><DTS:Property DTS:Name="CreationName"></DTS:Property></DTS:PackageVariable><DTS:Property DTS:Name="ForceExecValue">0</DTS:Property><DTS:Property DTS:Name="ExecValue" DTS:DataType="3">0</DTS:Property><DTS:Property DTS:Name="ForceExecutionResult">-1</DTS:Property><DTS:Property DTS:Name="Disabled">0</DTS:Property><DTS:Property DTS:Name="FailPackageOnFailure">0</DTS:Property><DTS:Property DTS:Name="FailParentOnFailure">0</DTS:Property><DTS:Property DTS:Name="MaxErrorCount">1</DTS:Property><DTS:Property DTS:Name="ISOLevel">1048576</DTS:Property><DTS:Property DTS:Name="LocaleID">1033</DTS:Property><DTS:Property DTS:Name="TransactionOption">1</DTS:Property><DTS:Property DTS:Name="DelayValidation">0</DTS:Property>
<DTS:Variable><DTS:Property DTS:Name="Expression"></DTS:Property><DTS:Property DTS:Name="EvaluateAsExpression">0</DTS:Property><DTS:Property DTS:Name="Namespace">User</DTS:Property><DTS:Property DTS:Name="ReadOnly">0</DTS:Property><DTS:Property DTS:Name="RaiseChangedEvent">0</DTS:Property><DTS:VariableValue DTS:DataType="8"></DTS:VariableValue><DTS:Property DTS:Name="ObjectName">FILESINFOLDER</DTS:Property><DTS:Property DTS:Name="DTSID">{097AEA90-7896-4EAE-903C-B4D4A76A43E2}</DTS:Property><DTS:Property DTS:Name="Description"></DTS:Property><DTS:Property DTS:Name="CreationName"></DTS:Property></DTS:Variable>
<DTS:LoggingOptions><DTS:Property DTS:Name="LoggingMode">0</DTS:Property><DTS:Property DTS:Name="FilterKind">1</DTS:Property><DTS:Property DTS:Name="EventFilter" DTS:DataType="8"></DTS:Property></DTS:LoggingOptions>
<DTS:Executable DTS:ExecutableType="Microsoft.SqlServer.Dts.Tasks.WmiDataReaderTask.WmiDataReaderTask, Microsoft.SqlServer.WMIDRTask, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" DTS:ThreadHint="0"><DTS:Property DTS:Name="ExecutionLocation">0</DTS:Property><DTS:Property DTS:Name="ExecutionAddress"></DTS:Property><DTS:Property DTS:Name="TaskContact">WMI Data Reader Task; Microsoft Corporation; Microsoft SQL Server v9; ? 2004 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;1</DTS:Property><DTS:Property DTS:Name="ForceExecValue">0</DTS:Property><DTS:Property DTS:Name="ExecValue" DTS:DataType="3">0</DTS:Property><DTS:Property DTS:Name="ForceExecutionResult">-1</DTS:Property><DTS:Property DTS:Name="Disabled">0</DTS:Property><DTS:Property DTS:Name="FailPackageOnFailure">0</DTS:Property><DTS:Property DTS:Name="FailParentOnFailure">0</DTS:Property><DTS:Property DTS:Name="MaxErrorCount">1</DTS:Property><DTS:Property DTS:Name="ISOLevel">1048576</DTS:Property><DTS:Property DTS:Name="LocaleID">-1</DTS:Property><DTS:Property DTS:Name="TransactionOption">1</DTS:Property><DTS:Property DTS:Name="DelayValidation">0</DTS:Property>
<DTS:Variable><DTS:Property DTS:Name="Expression"></DTS:Property><DTS:Property DTS:Name="EvaluateAsExpression">0</DTS:Property><DTS:Property DTS:Name="Namespace">User</DTS:Property><DTS:Property DTS:Name="ReadOnly">0</DTS:Property><DTS:Property DTS:Name="RaiseChangedEvent">0</DTS:Property><DTS:VariableValue DTS:DataType="8">C:</DTS:VariableValue><DTS:Property DTS:Name="ObjectName">DRIVETOLOOKIN</DTS:Property><DTS:Property DTS:Name="DTSID">{B7155D35-4B05-4C8E-948D-04CFC50A9BEA}</DTS:Property><DTS:Property DTS:Name="Description"></DTS:Property><DTS:Property DTS:Name="CreationName"></DTS:Property></DTS:Variable>
<DTS:Variable><DTS:Property DTS:Name="Expression"></DTS:Property><DTS:Property DTS:Name="EvaluateAsExpression">0</DTS:Property><DTS:Property DTS:Name="Namespace">User</DTS:Property><DTS:Property DTS:Name="ReadOnly">0</DTS:Property><DTS:Property DTS:Name="RaiseChangedEvent">0</DTS:Property><DTS:VariableValue DTS:DataType="8">TEMP\\TEMP</DTS:VariableValue><DTS:Property DTS:Name="ObjectName">FOLDERTOLOOKIN</DTS:Property><DTS:Property DTS:Name="DTSID">{F364298F-9E71-4D22-A0E3-394F6DDC73F7}</DTS:Property><DTS:Property DTS:Name="Description"></DTS:Property><DTS:Property DTS:Name="CreationName"></DTS:Property></DTS:Variable>
<DTS:LoggingOptions><DTS:Property DTS:Name="LoggingMode">0</DTS:Property><DTS:Property DTS:Name="FilterKind">1</DTS:Property><DTS:Property DTS:Name="EventFilter" DTS:DataType="8"></DTS:Property></DTS:LoggingOptions><DTS:PropertyExpression DTS:Name="WqlQuerySource">"Select name from cim_datafile where path = \"\\\\" + @.[User::FOLDERTOLOOKIN] + "\\\\\" and drive = \"" + @.[User::DRIVETOLOOKIN] + "\""</DTS:PropertyExpression><DTS:Property DTS:Name="ObjectName">WMI Data Reader Task 1</DTS:Property><DTS:Property DTS:Name="DTSID">{14485c88-8b76-4591-86b2-5ed365bf4fff}</DTS:Property><DTS:Property DTS:Name="Description">WMI Data Reader Task</DTS:Property><DTS:Property DTS:Name="CreationName">Microsoft.SqlServer.Dts.Tasks.WmiDataReaderTask.WmiDataReaderTask, Microsoft.SqlServer.WMIDRTask, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91</DTS:Property><DTS:Property DTS:Name="DisableEventHandlers">0</DTS:Property><DTS:ObjectData><WMIDRTaskData WQLQuerySourceType="DirectInput" WQLQuerySource="Select name from cim_datafile where path = &quot;\\TEMP\\TEMP\\&quot; and drive = &quot;C:&quot;" DestinationType="Variable" Destination="FILESINFOLDER" OverwriteDestination="OverwriteDestination" OutputType="PropertyValue" WMIConnectionName="{9f10cc24-7919-4cec-85a0-cde454c7598d}"/></DTS:ObjectData></DTS:Executable>
<DTS:Executable DTS:ExecutableType="Microsoft.SqlServer.Dts.Tasks.ScriptTask.ScriptTask, Microsoft.SqlServer.ScriptTask, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" DTS:ThreadHint="0"><DTS:Property DTS:Name="ExecutionLocation">0</DTS:Property><DTS:Property DTS:Name="ExecutionAddress"></DTS:Property><DTS:Property DTS:Name="TaskContact"></DTS:Property><DTS:Property DTS:Name="ForceExecValue">0</DTS:Property><DTS:Property DTS:Name="ExecValue" DTS:DataType="3">0</DTS:Property><DTS:Property DTS:Name="ForceExecutionResult">-1</DTS:Property><DTS:Property DTS:Name="Disabled">0</DTS:Property><DTS:Property DTS:Name="FailPackageOnFailure">0</DTS:Property><DTS:Property DTS:Name="FailParentOnFailure">0</DTS:Property><DTS:Property DTS:Name="MaxErrorCount">1</DTS:Property><DTS:Property DTS:Name="ISOLevel">1048576</DTS:Property><DTS:Property DTS:Name="LocaleID">-1</DTS:Property><DTS:Property DTS:Name="TransactionOption">1</DTS:Property><DTS:Property DTS:Name="DelayValidation">0</DTS:Property>
<DTS:LoggingOptions><DTS:Property DTS:Name="LoggingMode">0</DTS:Property><DTS:Property DTS:Name="FilterKind">1</DTS:Property><DTS:Property DTS:Name="EventFilter" DTS:DataType="8"></DTS:Property></DTS:LoggingOptions><DTS:Property DTS:Name="ObjectName">Script Task 1</DTS:Property><DTS:Property DTS:Name="DTSID">{933205d3-faf5-4a35-813a-c691178d0523}</DTS:Property><DTS:Property DTS:Name="Description">Script Task</DTS:Property><DTS:Property DTS:Name="CreationName">Microsoft.SqlServer.Dts.Tasks.ScriptTask.ScriptTask, Microsoft.SqlServer.ScriptTask, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91</DTS:Property><DTS:Property DTS:Name="DisableEventHandlers">0</DTS:Property><DTS:ObjectData><ScriptProject Name="ScriptTask_a882e6d3ef7b4f7fa60dabb8cb385b8f" Language="Microsoft Visual Basic .NET" EntryPoint="ScriptMain" SaveBinaries="False" ReadOnlyVariables="FILESINFOLDER" ReadWriteVariables=""><ProjectItem Name="dts://Scripts/ScriptTask_a882e6d3ef7b4f7fa60dabb8cb385b8f/ScriptTask_a882e6d3ef7b4f7fa60dabb8cb385b8f.vsaproj">
<![CDATA[<VisualStudioProject>
<VisualBasic
Version = "8.0.50215.44"
MVID = "{00000000-0000-0000-0000-000000000000}"
ProjectType = "Local"
ProductVersion = "8.0.50215"
SchemaVersion = "2.0"
>
<Build>
<Settings
DefaultNamespace = "ScriptTask_c368a900ee8149faae12a8a8995e6029"
OptionCompare = "0"
OptionExplicit = "0"
OptionStrict = "0"
ProjectName = "ScriptTask_c368a900ee8149faae12a8a8995e6029"
ReferencePath = "C:\WINDOWS\assembly\GAC_MSIL\Microsoft.SqlServer.ScriptTask\9.0.242.0__89845dcd8080cc91\;C:\WINDOWS\assembly\GAC_MSIL\Microsoft.SqlServer.ManagedDTS\9.0.242.0__89845dcd8080cc91\"
TreatWarningsAsErrors = "false"
WarningLevel = "1"
RootNamespace = "ScriptTask_c368a900ee8149faae12a8a8995e6029"
>
<Config
Name = "Debug"
DefineConstants = ""
DefineDebug = "true"
DefineTrace = "true"
DebugSymbols = "true"
RemoveIntegerChecks = "false"
/>
</Settings>
<References>
<Reference
Name = "System"
AssemblyName = "System"
/>
<Reference
Name = "System.Data"
AssemblyName = "System.Data"
/>
<Reference
Name = "Microsoft.SqlServer.ScriptTask"
AssemblyName = "Microsoft.SqlServer.ScriptTask"
/>
<Reference
Name = "Microsoft.SqlServer.ManagedDTS"
AssemblyName = "Microsoft.SqlServer.ManagedDTS"
/>
</References>
<Imports>
<Import Namespace = "Microsoft.VisualBasic" />
</Imports>
</Build>
<Files>
<Include>
<File
RelPath = "ScriptMain"
BuildAction = "Compile"
ItemType = "2"
/>
<VSAAppGlobal
VSAAppGlobalName = "Dts"
ItemType = "1"
VSAAppGlobalType = "Microsoft.SqlServer.Dts.Tasks.ScriptTask.ScriptObjectModel"
/>
</Include>
</Files>
<Folders>
<Include/>
</Folders>
</VisualBasic>
</VisualStudioProject>]]></ProjectItem><ProjectItem Name="dts://Scripts/ScriptTask_a882e6d3ef7b4f7fa60dabb8cb385b8f/ScriptMain.vsaitem">
<![CDATA[' Microsoft SQL Server Integration Services Script Task
' Write scripts using Microsoft Visual Basic
' The ScriptMain class is the entry point of the Script Task.

Imports System
Imports System.Data
Imports System.Math
Imports Microsoft.SqlServer.Dts.Runtime

Public Class ScriptMain

' The execution engine calls this method when the task executes.
' To access the object model, use the Dts object. Connections, variables, events,
' and logging features are available as static members of the Dts class.
' Before returning from this method, set the value of Dts.TaskResult to indicate success or failure.
'
' To open Code and Text Editor Help, press F1.
' To open Object Browser, press Ctrl+Alt+J.

Public Sub Main()
'
' Add your code here
'
Dim intLength As Integer = Dts.Variables("FILESINFOLDER").Value.ToString().Length
MsgBox("The number of bytes returned was : " + intLength.ToString() + Chr(13) + Chr(10) + Chr(13) + Chr(10) + Dts.Variables("FILESINFOLDER").Value, MsgBoxStyle.OKOnly, "WMI Data Reader Sample")
Dts.TaskResult = Dts.Results.Success
End Sub

End Class]]></ProjectItem></ScriptProject></DTS:ObjectData></DTS:Executable>
<DTS:PrecedenceConstraint><DTS:Property DTS:Name="Value">0</DTS:Property><DTS:Property DTS:Name="EvalOp">2</DTS:Property><DTS:Property DTS:Name="LogicalAnd">-1</DTS:Property><DTS:Property DTS:Name="Expression"></DTS:Property><DTS:Executable IDREF="{14485c88-8b76-4591-86b2-5ed365bf4fff}" DTS:IsFrom="-1"/><DTS:Executable IDREF="{933205d3-faf5-4a35-813a-c691178d0523}" DTS:IsFrom="0"/><DTS:Property DTS:Name="ObjectName">Constraint 1</DTS:Property><DTS:Property DTS:Name="DTSID">{e446313d-d87f-48a3-b358-c9a2df9d032e}</DTS:Property><DTS:Property DTS:Name="Description"></DTS:Property><DTS:Property DTS:Name="CreationName"></DTS:Property></DTS:PrecedenceConstraint><DTS:Property DTS:Name="ObjectName">CheckingForFilesInAFolder</DTS:Property><DTS:Property DTS:Name="DTSID">{586389B6-EA85-4C59-A7DA-240197FDAF89}</DTS:Property><DTS:Property DTS:Name="Description"></DTS:Property><DTS:Property DTS:Name="CreationName">MSDTS.Package.1</DTS:Property><DTS:Property DTS:Name="DisableEventHandlers">0</DTS:Property></DTS:Executable>

|||

Hi Anjan,

Thanks for your reply. But, I'm not sure how I can get WMI connection manager to connect FTP server and check if files exist. May be I'm missing something. Is it possible to capture the ExecResult of FTP task when it fails and do something in script task?

Please shed somelight.

Thanks.

|||

You could enable remote connections via WMI.

I guess you could do this with a script task, with just a few changes to the WQL query you can not only check local file system folders, but remote ones as well.

|||

Anjan,

Could you please be more specific on this becoz I'm not very familiar with SSIS? I was not able to figure out how to enable remote connections in WMI connection manager. I really appreciate your help on this.

Thanks.

|||

You might want to check the following

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/wmisdk/wmi/connecting_to_wmi_on_a_remote_computer.asp

http://www.ks-soft.net/hostmon.eng/wmi/index.htm

http://weblogs.foxite.com/stuartdunkeld/archive/2005/09/14/910.aspx

|||

SSIS newbie - There is a property in the FTP Task Editor called "StopOnFailure", set that to False. You could also set up a precedence constraint to check for Failure.

I'm not sure if this will help or not but it is something to try.

FTP Task error when no files found on FTP

Hi,

I have created a FTP task that logs into FTP server and receives files and scheduled it to run every 15min. However, it fails when there are no files on FTP. How would I check the if files exist? How can I catch the FTP task error and compare it to Hresults.NoFilesFound in a script task?

Thanks in advance for any help.

Here is a package that uses the WMI DataReader task to check a folder for files (Thanks Kirk).

Change the FOLDERTOLOOKIN variable to tell it what the folder name is, eg -> FilesDrop\\NewFiles

Change the DRIVETOLOOKIN variable to tell it what drive you're on, eg -> C:

The package uses a script task to show the fully qualified names of the files in the given folder.

The package outputs the names of the files to the FILESINFOLDER variable.

You can use a variety of ways to determine if the files are there.

This package does uses an expression on the precedence constraint to determine if the length of list of file names is greater than 0.

The script task only executes if there are files in the folder you specify. There is no mandatory script in this package. Only demo script to show a message box.

I'm not able to enclose the package so pasted it inline.

<save the following into a new package (.dtsx) >

<?xml version="1.0"?><DTS:Executable xmlns:DTS="www.microsoft.com/SqlServer/Dts" DTS:ExecutableType="MSDTS.Package.1"><DTS:Property DTS:Name="PackageFormatVersion">2</DTS:Property><DTS:Property DTS:Name="VersionComments"></DTS:Property><DTS:Property DTS:Name="CreatorName">DIGITALDARKROOM\Kirk</DTS:Property><DTS:Property DTS:Name="CreatorComputerName">DIGITALDARKROOM</DTS:Property><DTS:Property DTS:Name="CreationDate" DTS:DataType="7">8/24/2005 2:31:04 PM</DTS:Property><DTS:Property DTS:Name="PackageType">5</DTS:Property><DTS:Property DTS:Name="ProtectionLevel">1</DTS:Property><DTS:Property DTS:Name="MaxConcurrentExecutables">-1</DTS:Property><DTS:Property DTS:Name="PackagePriorityClass">0</DTS:Property><DTS:Property DTS:Name="VersionMajor">1</DTS:Property><DTS:Property DTS:Name="VersionMinor">0</DTS:Property><DTS:Property DTS:Name="VersionBuild">5</DTS:Property><DTS:Property DTS:Name="VersionGUID">{48AF8158-4E9E-4541-A6AB-021099D0FE8A}</DTS:Property><DTS:Property DTS:Name="EnableConfig">0</DTS:Property><DTS:Property DTS:Name="CheckpointFileName"></DTS:Property><DTS:Property DTS:Name="SaveCheckpoints">0</DTS:Property><DTS:Property DTS:Name="CheckpointUsage">0</DTS:Property><DTS:Property DTS:Name="SuppressConfigurationWarnings">0</DTS:Property>
<DTS:ConnectionManager><DTS:Property DTS:Name="ObjectName">WMI Connection Manager</DTS:Property><DTS:Property DTS:Name="DTSID">{9f10cc24-7919-4cec-85a0-cde454c7598d}</DTS:Property><DTS:Property DTS:Name="Description">Connect to the local machine</DTS:Property><DTS:Property DTS:Name="CreationName">WMI</DTS:Property><DTS:ObjectData><WmiConnectionManager ConnectionString="ServerName=\\localhost;Namespace=\root\cimv2;UseNtAuth=True;UserName=;"><PassWord Sensitive="1" Encrypted="1">AQAAANCMnd8BFdERjHoAwE/Cl+sBAAAAqOymPn/hnk6nIeKlG26CGwAAAAAIAAAARABUAFMAAAADZgAAqAAAABAAAADf2RDrYmm04gJhrINpTzv0AAAAAASAAACgAAAAEAAAANKvr+kiwtHe1Gytu3jMIn4IAAAANMWO/krUx8MUAAAA5pODGqAD7RkcBRU1wcntq02Ne74&lt;</PassWord></WmiConnectionManager></DTS:ObjectData></DTS:ConnectionManager>
<DTS:PackageVariable><DTS:Property DTS:Name="PackageVariableValue" DTS:DataType="8">&lt;Package xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:dwd="http://schemas.microsoft.com/DataWarehouse/Designer/1.0"&gt;&lt;dwd:DtsControlFlowDiagram&gt;&lt;dwd:BoundingTop&gt;2646&lt;/dwd:BoundingTop&gt;&lt;dwd:Layout&gt;&lt;dds&gt;
&lt;diagram fontclsid="{0BE35203-8F91-11CE-9DE3-00AA004BB851}" mouseiconclsid="{0BE35204-8F91-11CE-9DE3-00AA004BB851}" defaultlayout="Microsoft.DataWarehouse.Layout.GraphLayout" defaultlineroute="Microsoft.DataWarehouse.Layout.GraphLayout" version="7" nextobject="6" scale="100" pagebreakanchorx="0" pagebreakanchory="0" pagebreaksizex="0" pagebreaksizey="0" scrollleft="0" scrolltop="0" gridx="150" gridy="150" marginx="1000" marginy="1000" zoom="100" x="19209" y="13467" backcolor="15334399" defaultpersistence="2" PrintPageNumbersMode="3" PrintMarginTop="0" PrintMarginBottom="635" PrintMarginLeft="0" PrintMarginRight="0" marqueeselectionmode="1" mousepointer="0" snaptogrid="0" autotypeannotation="1" showscrollbars="0" viewpagebreaks="0" donotforceconnectorsbehindshapes="1" backpictureclsid="{00000000-0000-0000-0000-000000000000}"&gt;
&lt;font&gt;
&lt;ddsxmlobjectstreamwrapper binary="01000000bc02803801000756657264616e61" /&gt;
&lt;/font&gt;
&lt;mouseicon&gt;
&lt;ddsxmlobjectstreamwrapper binary="6c74000000000000" /&gt;
&lt;/mouseicon&gt;
&lt;/diagram&gt;
&lt;layoutmanager&gt;
&lt;ddsxmlobj /&gt;
&lt;/layoutmanager&gt;
&lt;ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.1" tooltip="WMI Data Reader Task" left="2910" top="2646" logicalid="3" controlid="3" masterid="0" hint1="0" hint2="0" width="3598" height="1164" noresize="0" nomove="0" nodefaultattachpoints="0" autodrag="1" usedefaultiddshape="1" selectable="1" showselectionhandles="1" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0"&gt;
&lt;control&gt;
&lt;ddsxmlobjectstreaminitwrapper binary="000800000e0e00008c040000" /&gt;
&lt;/control&gt;
&lt;layoutobject&gt;
&lt;ddsxmlobj&gt;
&lt;property name="LogicalObject" value="{14485c88-8b76-4591-86b2-5ed365bf4fff}" vartype="8" /&gt;
&lt;property name="ShowConnectorSource" value="0" vartype="2" /&gt;
&lt;/ddsxmlobj&gt;
&lt;/layoutobject&gt;
&lt;shape groupshapeid="0" groupnode="0" /&gt;
&lt;/ddscontrol&gt;
&lt;ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.1" tooltip="Script Task" left="2934" top="5651" logicalid="4" controlid="4" masterid="0" hint1="0" hint2="0" width="4868" height="1164" noresize="0" nomove="0" nodefaultattachpoints="0" autodrag="1" usedefaultiddshape="1" selectable="1" showselectionhandles="1" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0"&gt;
&lt;control&gt;
&lt;ddsxmlobjectstreaminitwrapper binary="00080000041300008c040000" /&gt;
&lt;/control&gt;
&lt;layoutobject&gt;
&lt;ddsxmlobj&gt;
&lt;property name="LogicalObject" value="{933205d3-faf5-4a35-813a-c691178d0523}" vartype="8" /&gt;
&lt;property name="ShowConnectorSource" value="0" vartype="2" /&gt;
&lt;/ddsxmlobj&gt;
&lt;/layoutobject&gt;
&lt;shape groupshapeid="0" groupnode="0" /&gt;
&lt;/ddscontrol&gt;
&lt;ddscontrol controlprogid="MSDDS.Polyline" left="4310" top="3411" logicalid="5" controlid="5" masterid="0" hint1="0" hint2="0" width="1458" height="2740" noresize="0" nomove="0" nodefaultattachpoints="1" autodrag="0" usedefaultiddshape="0" selectable="1" showselectionhandles="0" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0"&gt;
&lt;control&gt;
&lt;ddsxmlobj&gt;
&lt;polyline endtypedst="3" endtypesrc="1" usercolor="32768" linestyle="0" linerender="2" customendtypedstid="0" customendtypesrcid="0" adornsvisible="1" /&gt;
&lt;/ddsxmlobj&gt;
&lt;/control&gt;
&lt;layoutobject&gt;
&lt;ddsxmlobj&gt;
&lt;property name="LogicalObject" value="{e446313d-d87f-48a3-b358-c9a2df9d032e}" vartype="8" /&gt;
&lt;property name="Virtual" value="0" vartype="11" /&gt;
&lt;property name="VisibleAP" value="0" vartype="3" /&gt;
&lt;/ddsxmlobj&gt;
&lt;/layoutobject&gt;
&lt;connector sourceid="3" destid="4" sourceattachpoint="7" destattachpoint="8" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0"&gt;
&lt;point x="4709" y="3810" /&gt;
&lt;point x="4709" y="4730" /&gt;
&lt;point x="5368" y="4730" /&gt;
&lt;point x="5368" y="5651" /&gt;
&lt;/connector&gt;
&lt;/ddscontrol&gt;
&lt;/dds&gt;&lt;/dwd:Layout&gt;&lt;/dwd:DtsControlFlowDiagram&gt;&lt;/Package&gt;</DTS:Property><DTS:Property DTS:Name="Namespace">dts-designer-1.0</DTS:Property><DTS:Property DTS:Name="ObjectName">{586389B6-EA85-4C59-A7DA-240197FDAF89}</DTS:Property><DTS:Property DTS:Name="DTSID">{575D6A04-5089-4C0F-9C60-0AA14F70540A}</DTS:Property><DTS:Property DTS:Name="Description"></DTS:Property><DTS:Property DTS:Name="CreationName"></DTS:Property></DTS:PackageVariable><DTS:Property DTS:Name="ForceExecValue">0</DTS:Property><DTS:Property DTS:Name="ExecValue" DTS:DataType="3">0</DTS:Property><DTS:Property DTS:Name="ForceExecutionResult">-1</DTS:Property><DTS:Property DTS:Name="Disabled">0</DTS:Property><DTS:Property DTS:Name="FailPackageOnFailure">0</DTS:Property><DTS:Property DTS:Name="FailParentOnFailure">0</DTS:Property><DTS:Property DTS:Name="MaxErrorCount">1</DTS:Property><DTS:Property DTS:Name="ISOLevel">1048576</DTS:Property><DTS:Property DTS:Name="LocaleID">1033</DTS:Property><DTS:Property DTS:Name="TransactionOption">1</DTS:Property><DTS:Property DTS:Name="DelayValidation">0</DTS:Property>
<DTS:Variable><DTS:Property DTS:Name="Expression"></DTS:Property><DTS:Property DTS:Name="EvaluateAsExpression">0</DTS:Property><DTS:Property DTS:Name="Namespace">User</DTS:Property><DTS:Property DTS:Name="ReadOnly">0</DTS:Property><DTS:Property DTS:Name="RaiseChangedEvent">0</DTS:Property><DTS:VariableValue DTS:DataType="8"></DTS:VariableValue><DTS:Property DTS:Name="ObjectName">FILESINFOLDER</DTS:Property><DTS:Property DTS:Name="DTSID">{097AEA90-7896-4EAE-903C-B4D4A76A43E2}</DTS:Property><DTS:Property DTS:Name="Description"></DTS:Property><DTS:Property DTS:Name="CreationName"></DTS:Property></DTS:Variable>
<DTS:LoggingOptions><DTS:Property DTS:Name="LoggingMode">0</DTS:Property><DTS:Property DTS:Name="FilterKind">1</DTS:Property><DTS:Property DTS:Name="EventFilter" DTS:DataType="8"></DTS:Property></DTS:LoggingOptions>
<DTS:Executable DTS:ExecutableType="Microsoft.SqlServer.Dts.Tasks.WmiDataReaderTask.WmiDataReaderTask, Microsoft.SqlServer.WMIDRTask, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" DTS:ThreadHint="0"><DTS:Property DTS:Name="ExecutionLocation">0</DTS:Property><DTS:Property DTS:Name="ExecutionAddress"></DTS:Property><DTS:Property DTS:Name="TaskContact">WMI Data Reader Task; Microsoft Corporation; Microsoft SQL Server v9; ? 2004 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;1</DTS:Property><DTS:Property DTS:Name="ForceExecValue">0</DTS:Property><DTS:Property DTS:Name="ExecValue" DTS:DataType="3">0</DTS:Property><DTS:Property DTS:Name="ForceExecutionResult">-1</DTS:Property><DTS:Property DTS:Name="Disabled">0</DTS:Property><DTS:Property DTS:Name="FailPackageOnFailure">0</DTS:Property><DTS:Property DTS:Name="FailParentOnFailure">0</DTS:Property><DTS:Property DTS:Name="MaxErrorCount">1</DTS:Property><DTS:Property DTS:Name="ISOLevel">1048576</DTS:Property><DTS:Property DTS:Name="LocaleID">-1</DTS:Property><DTS:Property DTS:Name="TransactionOption">1</DTS:Property><DTS:Property DTS:Name="DelayValidation">0</DTS:Property>
<DTS:Variable><DTS:Property DTS:Name="Expression"></DTS:Property><DTS:Property DTS:Name="EvaluateAsExpression">0</DTS:Property><DTS:Property DTS:Name="Namespace">User</DTS:Property><DTS:Property DTS:Name="ReadOnly">0</DTS:Property><DTS:Property DTS:Name="RaiseChangedEvent">0</DTS:Property><DTS:VariableValue DTS:DataType="8">C:</DTS:VariableValue><DTS:Property DTS:Name="ObjectName">DRIVETOLOOKIN</DTS:Property><DTS:Property DTS:Name="DTSID">{B7155D35-4B05-4C8E-948D-04CFC50A9BEA}</DTS:Property><DTS:Property DTS:Name="Description"></DTS:Property><DTS:Property DTS:Name="CreationName"></DTS:Property></DTS:Variable>
<DTS:Variable><DTS:Property DTS:Name="Expression"></DTS:Property><DTS:Property DTS:Name="EvaluateAsExpression">0</DTS:Property><DTS:Property DTS:Name="Namespace">User</DTS:Property><DTS:Property DTS:Name="ReadOnly">0</DTS:Property><DTS:Property DTS:Name="RaiseChangedEvent">0</DTS:Property><DTS:VariableValue DTS:DataType="8">TEMP\\TEMP</DTS:VariableValue><DTS:Property DTS:Name="ObjectName">FOLDERTOLOOKIN</DTS:Property><DTS:Property DTS:Name="DTSID">{F364298F-9E71-4D22-A0E3-394F6DDC73F7}</DTS:Property><DTS:Property DTS:Name="Description"></DTS:Property><DTS:Property DTS:Name="CreationName"></DTS:Property></DTS:Variable>
<DTS:LoggingOptions><DTS:Property DTS:Name="LoggingMode">0</DTS:Property><DTS:Property DTS:Name="FilterKind">1</DTS:Property><DTS:Property DTS:Name="EventFilter" DTS:DataType="8"></DTS:Property></DTS:LoggingOptions><DTS:PropertyExpression DTS:Name="WqlQuerySource">"Select name from cim_datafile where path = \"\\\\" + @.[User::FOLDERTOLOOKIN] + "\\\\\" and drive = \"" + @.[User::DRIVETOLOOKIN] + "\""</DTS:PropertyExpression><DTS:Property DTS:Name="ObjectName">WMI Data Reader Task 1</DTS:Property><DTS:Property DTS:Name="DTSID">{14485c88-8b76-4591-86b2-5ed365bf4fff}</DTS:Property><DTS:Property DTS:Name="Description">WMI Data Reader Task</DTS:Property><DTS:Property DTS:Name="CreationName">Microsoft.SqlServer.Dts.Tasks.WmiDataReaderTask.WmiDataReaderTask, Microsoft.SqlServer.WMIDRTask, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91</DTS:Property><DTS:Property DTS:Name="DisableEventHandlers">0</DTS:Property><DTS:ObjectData><WMIDRTaskData WQLQuerySourceType="DirectInput" WQLQuerySource="Select name from cim_datafile where path = &quot;\\TEMP\\TEMP\\&quot; and drive = &quot;C:&quot;" DestinationType="Variable" Destination="FILESINFOLDER" OverwriteDestination="OverwriteDestination" OutputType="PropertyValue" WMIConnectionName="{9f10cc24-7919-4cec-85a0-cde454c7598d}"/></DTS:ObjectData></DTS:Executable>
<DTS:Executable DTS:ExecutableType="Microsoft.SqlServer.Dts.Tasks.ScriptTask.ScriptTask, Microsoft.SqlServer.ScriptTask, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" DTS:ThreadHint="0"><DTS:Property DTS:Name="ExecutionLocation">0</DTS:Property><DTS:Property DTS:Name="ExecutionAddress"></DTS:Property><DTS:Property DTS:Name="TaskContact"></DTS:Property><DTS:Property DTS:Name="ForceExecValue">0</DTS:Property><DTS:Property DTS:Name="ExecValue" DTS:DataType="3">0</DTS:Property><DTS:Property DTS:Name="ForceExecutionResult">-1</DTS:Property><DTS:Property DTS:Name="Disabled">0</DTS:Property><DTS:Property DTS:Name="FailPackageOnFailure">0</DTS:Property><DTS:Property DTS:Name="FailParentOnFailure">0</DTS:Property><DTS:Property DTS:Name="MaxErrorCount">1</DTS:Property><DTS:Property DTS:Name="ISOLevel">1048576</DTS:Property><DTS:Property DTS:Name="LocaleID">-1</DTS:Property><DTS:Property DTS:Name="TransactionOption">1</DTS:Property><DTS:Property DTS:Name="DelayValidation">0</DTS:Property>
<DTS:LoggingOptions><DTS:Property DTS:Name="LoggingMode">0</DTS:Property><DTS:Property DTS:Name="FilterKind">1</DTS:Property><DTS:Property DTS:Name="EventFilter" DTS:DataType="8"></DTS:Property></DTS:LoggingOptions><DTS:Property DTS:Name="ObjectName">Script Task 1</DTS:Property><DTS:Property DTS:Name="DTSID">{933205d3-faf5-4a35-813a-c691178d0523}</DTS:Property><DTS:Property DTS:Name="Description">Script Task</DTS:Property><DTS:Property DTS:Name="CreationName">Microsoft.SqlServer.Dts.Tasks.ScriptTask.ScriptTask, Microsoft.SqlServer.ScriptTask, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91</DTS:Property><DTS:Property DTS:Name="DisableEventHandlers">0</DTS:Property><DTS:ObjectData><ScriptProject Name="ScriptTask_a882e6d3ef7b4f7fa60dabb8cb385b8f" Language="Microsoft Visual Basic .NET" EntryPoint="ScriptMain" SaveBinaries="False" ReadOnlyVariables="FILESINFOLDER" ReadWriteVariables=""><ProjectItem Name="dts://Scripts/ScriptTask_a882e6d3ef7b4f7fa60dabb8cb385b8f/ScriptTask_a882e6d3ef7b4f7fa60dabb8cb385b8f.vsaproj">
<![CDATA[<VisualStudioProject>
<VisualBasic
Version = "8.0.50215.44"
MVID = "{00000000-0000-0000-0000-000000000000}"
ProjectType = "Local"
ProductVersion = "8.0.50215"
SchemaVersion = "2.0"
>
<Build>
<Settings
DefaultNamespace = "ScriptTask_c368a900ee8149faae12a8a8995e6029"
OptionCompare = "0"
OptionExplicit = "0"
OptionStrict = "0"
ProjectName = "ScriptTask_c368a900ee8149faae12a8a8995e6029"
ReferencePath = "C:\WINDOWS\assembly\GAC_MSIL\Microsoft.SqlServer.ScriptTask\9.0.242.0__89845dcd8080cc91\;C:\WINDOWS\assembly\GAC_MSIL\Microsoft.SqlServer.ManagedDTS\9.0.242.0__89845dcd8080cc91\"
TreatWarningsAsErrors = "false"
WarningLevel = "1"
RootNamespace = "ScriptTask_c368a900ee8149faae12a8a8995e6029"
>
<Config
Name = "Debug"
DefineConstants = ""
DefineDebug = "true"
DefineTrace = "true"
DebugSymbols = "true"
RemoveIntegerChecks = "false"
/>
</Settings>
<References>
<Reference
Name = "System"
AssemblyName = "System"
/>
<Reference
Name = "System.Data"
AssemblyName = "System.Data"
/>
<Reference
Name = "Microsoft.SqlServer.ScriptTask"
AssemblyName = "Microsoft.SqlServer.ScriptTask"
/>
<Reference
Name = "Microsoft.SqlServer.ManagedDTS"
AssemblyName = "Microsoft.SqlServer.ManagedDTS"
/>
</References>
<Imports>
<Import Namespace = "Microsoft.VisualBasic" />
</Imports>
</Build>
<Files>
<Include>
<File
RelPath = "ScriptMain"
BuildAction = "Compile"
ItemType = "2"
/>
<VSAAppGlobal
VSAAppGlobalName = "Dts"
ItemType = "1"
VSAAppGlobalType = "Microsoft.SqlServer.Dts.Tasks.ScriptTask.ScriptObjectModel"
/>
</Include>
</Files>
<Folders>
<Include/>
</Folders>
</VisualBasic>
</VisualStudioProject>]]></ProjectItem><ProjectItem Name="dts://Scripts/ScriptTask_a882e6d3ef7b4f7fa60dabb8cb385b8f/ScriptMain.vsaitem">
<![CDATA[' Microsoft SQL Server Integration Services Script Task
' Write scripts using Microsoft Visual Basic
' The ScriptMain class is the entry point of the Script Task.

Imports System
Imports System.Data
Imports System.Math
Imports Microsoft.SqlServer.Dts.Runtime

Public Class ScriptMain

' The execution engine calls this method when the task executes.
' To access the object model, use the Dts object. Connections, variables, events,
' and logging features are available as static members of the Dts class.
' Before returning from this method, set the value of Dts.TaskResult to indicate success or failure.
'
' To open Code and Text Editor Help, press F1.
' To open Object Browser, press Ctrl+Alt+J.

Public Sub Main()
'
' Add your code here
'
Dim intLength As Integer = Dts.Variables("FILESINFOLDER").Value.ToString().Length
MsgBox("The number of bytes returned was : " + intLength.ToString() + Chr(13) + Chr(10) + Chr(13) + Chr(10) + Dts.Variables("FILESINFOLDER").Value, MsgBoxStyle.OKOnly, "WMI Data Reader Sample")
Dts.TaskResult = Dts.Results.Success
End Sub

End Class]]></ProjectItem></ScriptProject></DTS:ObjectData></DTS:Executable>
<DTS:PrecedenceConstraint><DTS:Property DTS:Name="Value">0</DTS:Property><DTS:Property DTS:Name="EvalOp">2</DTS:Property><DTS:Property DTS:Name="LogicalAnd">-1</DTS:Property><DTS:Property DTS:Name="Expression"></DTS:Property><DTS:Executable IDREF="{14485c88-8b76-4591-86b2-5ed365bf4fff}" DTS:IsFrom="-1"/><DTS:Executable IDREF="{933205d3-faf5-4a35-813a-c691178d0523}" DTS:IsFrom="0"/><DTS:Property DTS:Name="ObjectName">Constraint 1</DTS:Property><DTS:Property DTS:Name="DTSID">{e446313d-d87f-48a3-b358-c9a2df9d032e}</DTS:Property><DTS:Property DTS:Name="Description"></DTS:Property><DTS:Property DTS:Name="CreationName"></DTS:Property></DTS:PrecedenceConstraint><DTS:Property DTS:Name="ObjectName">CheckingForFilesInAFolder</DTS:Property><DTS:Property DTS:Name="DTSID">{586389B6-EA85-4C59-A7DA-240197FDAF89}</DTS:Property><DTS:Property DTS:Name="Description"></DTS:Property><DTS:Property DTS:Name="CreationName">MSDTS.Package.1</DTS:Property><DTS:Property DTS:Name="DisableEventHandlers">0</DTS:Property></DTS:Executable>

|||

Hi Anjan,

Thanks for your reply. But, I'm not sure how I can get WMI connection manager to connect FTP server and check if files exist. May be I'm missing something. Is it possible to capture the ExecResult of FTP task when it fails and do something in script task?

Please shed somelight.

Thanks.

|||

You could enable remote connections via WMI.

I guess you could do this with a script task, with just a few changes to the WQL query you can not only check local file system folders, but remote ones as well.

|||

Anjan,

Could you please be more specific on this becoz I'm not very familiar with SSIS? I was not able to figure out how to enable remote connections in WMI connection manager. I really appreciate your help on this.

Thanks.

|||

You might want to check the following

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/wmisdk/wmi/connecting_to_wmi_on_a_remote_computer.asp

http://www.ks-soft.net/hostmon.eng/wmi/index.htm

http://weblogs.foxite.com/stuartdunkeld/archive/2005/09/14/910.aspx

|||

SSIS newbie - There is a property in the FTP Task Editor called "StopOnFailure", set that to False. You could also set up a precedence constraint to check for Failure.

I'm not sure if this will help or not but it is something to try.

FTP task error occurring

This is strange... just started getting this today, while it's worked for weeks. But alas, that is programming.

The error I'm getting is

[Connection manager "FTP DQ Connection"] Error: An error occurred in the requested FTP operation. Detailed error description: 200 Type set to I. 200 Command okay. 550 /usfsr/DFE_INPUT/FATest_DQ.txt: No such file or folder. .

I'm uploading a file (FATest_DQ.txt) to the folder /usfsr/DFE_INPUT/. I eventually just uploaded the file manually using IE6 to make sure the connection properties were still the same.

Any ideas?They changed the folder name on me... heh. Problem solved.

FTP No Files Error

When running FTP Client, and there are no files found on the FTP site and
error is thrown. Is there any way to catch this condition and reset the
error so does not bubble up to the parent package?

I want to catch the event that there are not files on the FTP server to get
so that I can set a variable appropriately, but then I want to branch on the
condition and return to the parent package and not have the parent package
see the error that was thrown.

Any suggestions?

Thanks, Mike

You can not catch this specific error condition.

You can control the execution result to be success, failure, or completion, but this will be the case always, not for specific errors only.

Thanks,
Mohammed.

|||Sorry forgot to mention how to control the execution result. You do that by setting the ForceExecutionResult property to the result you want (Success, Failure, or Completion)|||Thanks for the feedback. In the OnTaskFailed Event Handler, I would then like to be able to explicitly set the ForceExecutionResult = Completion. Is it possible to do this at this point? I have not be able to determine how to program this into my script that runs when this event occurs. Maybe this is just not possible.

My issue is that I have had to set the Max Error Count = 2 for the parent package that calls the FTP process to work past this issue. But then I have not way of determining if the error was due to the files not being there, or a legitimate error like the connection to the server could not be established.

I probably should put this on the wish list for an upcoming release.

Thanks, Mike.

FTP Download Task (with Overwrite) doesn't overwrite!!!!!!!!!!

Error with SSIS FTP download task:

How to recreate the error:

Download a file using the task.

Go to the file in Windows Exploder and Open the file in notepad.

Copy the last line of text and paste in a few extra rows at the bottom. So if you had 100 rows, you'll now have 103 rows.

Save the file.

Go back to the task and make sure you have "overwrite destination" set to True.

Execute the task.

Go back to the file and look at the bottom of the file. You'll see the same 3 extra rows you pasted in there.

That is not how it should work if it was supposed to be released like that.

Are there any patches that fix this error?

Ryan

I just confirmed Ryan's observations.

VS 2005 - 8.0.50727.42
SSIS - 9.00.2047.00

This looks like it's fixed and will be available in the next release.

https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=126467|||You might want to, in the interim, use a File System task to delete the file before going to the FTP task.

Phil|||

Yep. Got it, thanks!

Appreciate the feedback link. That's cool.

FTP Connection problem with "The Password was not allowed" error message

Hi

I have a simple FTP task that I am trying to connect to an FTP server. I can test the connection fine, however, when I try and execute the package from Visual Studio 2005 I get the "The Password was not allowed" message. I have found some threads that mention setting the protection level on the package to EncryptSensitiveWithPassword, however, I still get the same message appearing.

Has anyone any idea as to what is causing this and how I can get around it

Thanks

Darrell

The error comes from the FTP server due to a invalid password. Can you tell me what is the value ProtectionLevel property in the Package?

Thanks,

Ovidiu Burlacu

|||EncryptSensitiveWithPassword means you have to enter a password in the package properties. You have specified the wrong password there, most likely.

For running in BIDS, EncryptSensitiveWithUserKey is just fine.|||

I had set the PackageProtection to EncryptSensitiveWithPassword, but that didn't work either.

As for an incorrect password, this can't be correct, because when I test the FTP connection it works fine

Any other thoughts ?

Thanks

D

ft search error in win2k3 sp1 with sql 2k sp4?

I just setup my server with win2k3 sp1 and ALL the latest patches, plus
sql 2004 standard sp4.
I keep getting this error on a table with 39000 records where I am
running a basic wildcard CONTAINS fulltext query for "cer*"
Server: Msg 7643, Level 16, State 1, Line 1
Your search generated too many results. Please perform a more specific
search.
There should be about 30000 records.
I noticed on technet that this was a problem pre sp2 in sql, but was
since patched. Has the bug recently been re-introduced in some combo
of win2k3 and sql patches?
Phadke,
Yes, there was some additional logic added in SP3 that generates the below
error message. SQL FTS is optimized for returning 2000 results per query,
primarily for performance reasons. You may want to re-write your query using
CONTAINSTABLE and use the Top_N_by_Rank parameter to limit the results to
2000 or use a similar TOP restriction in the select list.
Regards,
John
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/
<phadke@.gmail.com> wrote in message
news:1129632193.545575.218860@.g47g2000cwa.googlegr oups.com...
>I just setup my server with win2k3 sp1 and ALL the latest patches, plus
> sql 2004 standard sp4.
> I keep getting this error on a table with 39000 records where I am
> running a basic wildcard CONTAINS fulltext query for "cer*"
> Server: Msg 7643, Level 16, State 1, Line 1
> Your search generated too many results. Please perform a more specific
> search.
> There should be about 30000 records.
> I noticed on technet that this was a problem pre sp2 in sql, but was
> since patched. Has the bug recently been re-introduced in some combo
> of win2k3 and sql patches?
>
|||John,
Just to clarify, is this a hard limit of 2000, because I am able to see
the result set for queries that return a con query with 17-18k records
with no problem.
I saw another technote that the problem limit was at approx 20k
records:
http://support.microsoft.com/default...;en-us;Q296456
Thanks for the info,
Aditya
|||Also, is this limitation common to sql 2005?
|||Ok, now I am really confused...I ran a fulltext query for "c*" on a
database on another server. This database has 2.4 Million Records.
This server is Win2k3 (no SP) and SQL 2k SP3.
When I run the query, I get 900,000 records back without an error
message.
|||Aditya,
Yes, this is the KB article that I couldn't find early this morning when in
a rush to get off to work...
Still for performance reasons, it might be best to use Top_N_Rank with
CONTAINSTABLE or is there a specific reason you want to return this many
rows?
Thanks,
John
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/
<phadke@.gmail.com> wrote in message
news:1129660216.247521.205300@.g47g2000cwa.googlegr oups.com...
> John,
> Just to clarify, is this a hard limit of 2000, because I am able to see
> the result set for queries that return a con query with 17-18k records
> with no problem.
> I saw another technote that the problem limit was at approx 20k
> records:
> http://support.microsoft.com/default...;en-us;Q296456
> Thanks for the info,
> Aditya
>
|||Aditya,
I need to confirm this with a large table in order to generate the large
results. However, I would suspect that it is still in SQL 2005 until proved
otherwise...
John
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/
"Aditya Phadke" <phadke@.gmail.com> wrote in message
news:1129660966.529955.176010@.g44g2000cwa.googlegr oups.com...
> Also, is this limitation common to sql 2005?
>
|||Aditya,
Different servers can behavior differently for FTS results based upon the OS
platform (different wordbreakers) and due to different noise word file
contents. In this case, and on this server is the single letter "C" removed
from the language-specific noise word file (noise.enu = US English) for the
specific FT-enable column's "Language for Word Breaker"?
As they say the devil is in the details... ;-)
Regards,
John
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/
"Aditya Phadke" <phadke@.gmail.com> wrote in message
news:1129672239.794380.257680@.o13g2000cwo.googlegr oups.com...
> Ok, now I am really confused...I ran a fulltext query for "c*" on a
> database on another server. This database has 2.4 Million Records.
> This server is Win2k3 (no SP) and SQL 2k SP3.
> When I run the query, I get 900,000 records back without an error
> message.
>

Frustrating Installation Error

I was installing SQL Server on my machine and during installation my PC
freezed. It happens frequently on my machine as my bad luck sticks frequenctly to my side. So i tried after
restarting to install it again and since then i always get the same
error message:
"An error occurred while creating one or more registry entries. Please
see C:\WINDOWS\sqlstp.log for details. The problem could be caused by a
low registry quota condition"
I have tried to clean the registry during the installation bt chosing "advanced options" -> "Rebuild registry" and i don't know what else i could
do to solve this issue. I'd like to remark that i also deleted the SQL Server keys from Registry as suggested from Microsoft to delete default and special named instances.

I also deleted every thing under %TEMP%; I even installed third pary registry tools to clean the registry such as RegistryFix, Registry Mechanic and AMUST.

Finally, i'm using Windows XP Professional SP2.

Any help?

The log file lists the following:

14:22:27 Begin Setup
14:22:27 8.00.194
14:22:27 Mode = Normal
14:22:27 ModeType = NORMAL
14:22:27 GetDefinitionEx returned: 0, Extended: 0x0
14:22:27 ValueFTS returned: 1
14:22:27 ValuePID returned: 1
14:22:27 ValueLic returned: 0
14:22:27 System: Windows NT WorkStation
14:22:27 SQL Server ProductType: Developer Edition [0x3]
14:22:27 Begin Action: SetupInitialize
14:22:27 End Action SetupInitialize
14:22:27 Begin Action: SetupInstall
14:22:27 Reading
Software\Microsoft\Windows\CurrentVersion\CommonFilesDir ...
14:22:27 CommonFilesDir=C:\Programme\Gemeinsame Dateien
14:22:27 Windows Directory=C:\WINDOWS\
14:22:27 Program Files=C:\Programme\
14:22:27 TEMPDIR=C:\WINDOWS\TEMP\
14:22:27 Begin Action: SetupInstall
14:22:27 digpid size : 256
14:22:27 digpid size : 164
14:22:27 Begin Action: CheckFixedRequirements
14:22:27 Platform ID: 0xf000000
14:22:27 Version: 5.1.2600
14:22:27 File Version - C:\WINDOWS\system32\shdocvw.dll: 6.0.2900.2805
14:22:27 End Action: CheckFixedRequirements
14:22:27 Begin Action: ShowDialogs
14:22:27 Initial Dialog Mask: 0x83000f7, Disable Back=0x1
14:22:27 Begin Action ShowDialogsHlpr: 0x1
14:22:27 Begin Action: DialogShowSdWelcome
14:22:28 End Action DialogShowSdWelcome
14:22:28 Dialog 0x1 returned: 1
14:22:28 End Action ShowDialogsHlpr
14:22:28 ShowDialogsGetDialog returned: nCurrent=0x2,index=1
14:22:28 Begin Action ShowDialogsHlpr: 0x2
14:22:28 Begin Action: DialogShowSdMachineName
14:22:30 ShowDlgMachine returned: 1
14:22:30 Name = COOSA, Type = 0x1
14:22:30 Begin Action: CheckRequirements
14:22:30 Processor Architecture: x86 (Pentium)
14:22:30 Service Pack: 512
14:22:30 ComputerName: COOSA
14:22:30 User Name: admin
14:22:30 IsAllAccessAllowed returned: 1
14:22:30 OS Language: 0x401
14:22:30 End Action CheckRequirements
14:22:30 This combination of Package and Operating System allows a full
product install.
14:22:30 CreateSetupTopology(COOSA), Handle : 0x1b04098, returned : 0
14:22:30 CreateSetupTopology returned : 0, Handle : 0x1b04098
14:22:30 Topology Type : 1, Return Value : 0
14:22:30 ST_GetPhysicalNode returned : 0, PNHandle : 0x1b040c0
14:22:30 PN_EnumerateEx returned : 0
14:22:30 PN_GetSQLStates returned : 0, SqlStates : 0x80000000
14:22:30 PN_StartScan [0x1b040c0] returned : 0
14:22:30 PN_GetNext [0x1b040c0] returned : 18, Handle: [0x0]
14:22:30 No more items in enumeration.
14:22:30 ReleaseSetupTopology
14:22:30 Named instance limit: 100, quota: 0
14:22:30 End Action DialogShowSdMachineName
14:22:30 begin ShowDialogsUpdateMask
14:22:30 nFullMask = 0x83000f7, nCurrent = 0x2, nDirection = 0
14:22:30 Updated Dialog Mask: 0xbf00037, Disable Back = 0x1
14:22:30 Dialog 0x2 returned: 0
14:22:30 End Action ShowDialogsHlpr
14:22:30 ShowDialogsGetDialog returned: nCurrent=0x4,index=2
14:22:30 Begin Action ShowDialogsHlpr: 0x4
14:22:30 Begin Action: DialogShowSdInstallMode
14:22:36 ShowDlgInstallMode returned: 1
14:22:36 InstallMode : 0x1
14:22:36 End Action DialogShowSdInstallMode
14:22:36 begin ShowDialogsUpdateMask
14:22:36 nFullMask = 0xbf00037, nCurrent = 0x4, nDirection = 1
14:22:36 Updated Dialog Mask: 0xbf40037, Disable Back = 0x1
14:22:36 Dialog 0x4 returned: 1
14:22:36 End Action ShowDialogsHlpr
14:22:36 ShowDialogsGetDialog returned: nCurrent=0x10,index=4
14:22:36 Begin Action ShowDialogsHlpr: 0x10
14:22:36 Begin Action: DialogShowSdRegisterUserEx
14:22:42 End Action DialogShowSdRegisterUserEx
14:22:42 Dialog 0x10 returned: 1
14:22:42 End Action ShowDialogsHlpr
14:22:42 ShowDialogsGetDialog returned: nCurrent=0x20,index=5
14:22:42 Begin Action ShowDialogsHlpr: 0x20
14:22:42 Begin Action: DialogShowSdLicense
14:22:43 End Action DialogShowSdLicense
14:22:43 Dialog 0x20 returned: 1
14:22:43 End Action ShowDialogsHlpr
14:22:43 ShowDialogsGetDialog returned: nCurrent=0x40000,index=18
14:22:43 Begin Action ShowDialogsHlpr: 0x40000
14:22:43 Begin Action: DialogShowSdCliSvr
14:22:43 DisplaySystemPreReq
14:22:45 ShowDlgClientServerSelect returned: 1
14:22:45 Type : 0x2
14:22:45 End Action DialogShowSdCliSvr
14:22:45 begin ShowDialogsUpdateMask
14:22:45 nFullMask = 0xbf40037, nCurrent = 0x40000, nDirection = 1
14:22:45 Updated Dialog Mask: 0xbfc0037, Disable Back = 0x1
14:22:45 Dialog 0x40000 returned: 1
14:22:45 End Action ShowDialogsHlpr
14:22:45 ShowDialogsGetDialog returned: nCurrent=0x80000,index=19
14:22:45 Begin Action ShowDialogsHlpr: 0x80000
14:22:45 Begin Action: DialogShowSdInstanceName
14:22:45 Begin Action: ShowDlgInstanceName
14:22:47 End Action: ShowDlgInstanceName
14:22:47 ShowDlgInstanceName returned : 1
14:22:47 InstanceName : MSSQLSERVER
14:22:47 CreateSetupTopology(COOSA), Handle : 0x1b04098, returned : 0
14:22:47 CreateSetupTopology returned : 0, Handle : 0x1b04098
14:22:47 Topology Type : 1, Return Value : 0
14:22:47 ST_GetPhysicalNode returned : 0, PNHandle : 0x1b040c0
14:22:47 PN_EnumerateEx returned : 0
14:22:47 PN_GetSQLStates returned : 0, SqlStates : 0x80000000
14:22:47 PN_StartScan [0x1b040c0] returned : 0
14:22:47 PN_GetNext [0x1b040c0] returned : 18, Handle: [0x0]
14:22:47 No more items in enumeration.
14:22:47 ReleaseSetupTopology
14:22:47 End Action DialogShowSdInstanceName
14:22:47 begin ShowDialogsUpdateMask
14:22:47 nFullMask = 0xbfc0037, nCurrent = 0x80000, nDirection = 1
14:22:47 Updated Dialog Mask: 0xbfc0037, Disable Back = 0x1
14:22:47 Dialog 0x80000 returned: 1
14:22:47 End Action ShowDialogsHlpr
14:22:47 ShowDialogsGetDialog returned: nCurrent=0x100000,index=20
14:22:47 Begin Action ShowDialogsHlpr: 0x100000
14:22:47 Begin Action: DialogShowSdSetupType
14:22:47 Begin Action: Setup Type
14:23:05 SQL program folder: C:\Programme\Microsoft SQL Server
14:23:05 SQL data folder: C:\Programme\Microsoft SQL Server
14:23:05 Windows system folder: C:\WINDOWS\system32\
14:23:05 Prog req: 38073, Data req: 34432, Sys req: 158694
14:23:05 Prog avail: 1481708, Data avail: 1481708, Sys avail: 1481708
14:23:05 Prog req vs. avail, 231199, 1481708
14:23:05 Data req vs. avail, 34432, 1481708
14:23:05 Sys req vs. avail, 193126, 1481708
14:23:05 DisplaySystemPreReq
14:23:05 [SetupTypeSQL]
14:23:05 szDir = C:\Programme\Microsoft SQL Server
14:23:05 szDir = %PROGRAMFILES%\Microsoft SQL Server
14:23:05 Result = 301
14:23:05 szDataDir = C:\Programme\Microsoft SQL Server
14:23:05 szDataDir = %PROGRAMFILES%\Microsoft SQL Server
14:23:05 End Action: Setup Type
14:23:05 Setup Type: Typical (301)
14:23:05 End Action DialogShowSdSetupType
14:23:05 begin ShowDialogsUpdateMask
14:23:05 nFullMask = 0xbfc0037, nCurrent = 0x100000, nDirection = 301
14:23:05 Updated Dialog Mask: 0xbdc0037, Disable Back = 0x1
14:23:05 Dialog 0x100000 returned: 301
14:23:05 End Action ShowDialogsHlpr
14:23:05 ShowDialogsGetDialog returned: nCurrent=0x400000,index=22
14:23:05 Begin Action ShowDialogsHlpr: 0x400000
14:23:05 Begin Action: DlgServices
14:23:10 ShowDlgServices returned: 1
14:23:10 [DlgServices]
14:23:10 Local-Domain = 3855
14:23:10 AutoStart = 15
14:23:10 Result = 1
14:23:10 End Action DlgServices
14:23:10 begin ShowDialogsUpdateMask
14:23:10 nFullMask = 0xbdc0037, nCurrent = 0x400000, nDirection = 1
14:23:10 Updated Dialog Mask: 0xbdc0037, Disable Back = 0x1
14:23:10 Dialog 0x400000 returned: 1
14:23:10 End Action ShowDialogsHlpr
14:23:10 ShowDialogsGetDialog returned: nCurrent=0x800000,index=23
14:23:10 Begin Action ShowDialogsHlpr: 0x800000
14:23:10 Begin Action: DlgSQLSecurity
14:23:12 ShowDlgSQLSecurity returned: 1
14:23:12 LoginMode = 1,szPwd
14:23:12 End Action DlgSQLSecurity
14:23:12 begin ShowDialogsUpdateMask
14:23:12 nFullMask = 0xbdc0037, nCurrent = 0x800000, nDirection = 1
14:23:12 Updated Dialog Mask: 0xbdc0037, Disable Back = 0x1
14:23:12 Dialog 0x800000 returned: 1
14:23:12 End Action ShowDialogsHlpr
14:23:12 ShowDialogsGetDialog returned: nCurrent=0x1000000,index=24
14:23:12 Begin Action ShowDialogsHlpr: 0x1000000
14:23:12 Begin Action: DlgCollation
14:23:12 ShowDlgCollation returned: 1
14:23:12 collation_name = Arabic_CI_AS,locale_name = Arabic,lcid =
0x401,SortId = 0,dwCompFlags = 0x30001
14:23:12 End Action DlgCollation
14:23:12 begin ShowDialogsUpdateMask
14:23:12 nFullMask = 0xbdc0037, nCurrent = 0x1000000, nDirection = 1
14:23:12 Updated Dialog Mask: 0xbdc0037, Disable Back = 0x1
14:23:12 Dialog 0x1000000 returned: 1
14:23:12 End Action ShowDialogsHlpr
14:23:12 ShowDialogsGetDialog returned: nCurrent=0x2000000,index=25
14:23:12 Begin Action ShowDialogsHlpr: 0x2000000
14:23:12 Begin Action: DlgNetwork
14:23:12 ShowDlgNetwork returned: 1
14:23:12 [DlgServerNetwork]
14:23:12 NetworkLibs = 255
14:23:12 TCPPort = 1433
14:23:12 TCPPrxy = Default
14:23:12 NMPPipeName = \\.\pipe\sql\query
14:23:12 Result = 1
14:23:12 End Action DlgNetwork
14:23:12 begin ShowDialogsUpdateMask
14:23:12 nFullMask = 0xbdc0037, nCurrent = 0x2000000, nDirection = 1
14:23:12 Updated Dialog Mask: 0xbdc0037, Disable Back = 0x1
14:23:12 Dialog 0x2000000 returned: 1
14:23:12 End Action ShowDialogsHlpr
14:23:12 ShowDialogsGetDialog returned: nCurrent=0x8000000,index=27
14:23:12 Begin Action ShowDialogsHlpr: 0x8000000
14:23:12 Begin Action: DialogShowSdStartCopy
14:23:13 End Action DialogShowSdStartCopy
14:23:13 begin ShowDialogsUpdateMask
14:23:13 nFullMask = 0xbdc0037, nCurrent = 0x8000000, nDirection = 1
14:23:13 Updated Dialog Mask: 0xbdc0037, Disable Back = 0x1
14:23:13 Dialog 0x8000000 returned: 1
14:23:13 End Action ShowDialogsHlpr
14:23:13 ShowDialogsGetDialog returned: nCurrent=0x0,index=0
14:23:13 End Action ShowDialogs
14:23:13 Begin Action ProcessBeforeDataMove:
14:23:13 DeinstallStart returned (C:\Programme\Microsoft SQL
Server\MSSQL): 0
14:23:13 End Action ProcessBeforeDataMove:
14:23:13 Begin Action SetToolsComponentSelection:
14:23:13 End Action SetToolsComponentSelection:
14:23:13 Begin Action ProcessComponentSelection:
14:23:13 End Action ProcessComponentSelection
14:23:13 Begin Action LogSelectedComponents:
14:23:13 SQLProg
14:23:13 SQLProg\SQLServr
14:23:13 SQLProg\SQLServr\Help
14:23:13 SQLProg\SQLServr\SCMDev
14:23:13 SQLProg\SQLServr\SCMDev\SCMh
14:23:13 SQLProg\SQLServr\SCMDev\SCMX86Lb
14:23:13 SQLProg\SQLServr\SCMDev\SCMALb
14:23:13 SQLProg\SQLServr\Rs1033
14:23:13 SQLProg\SQLServr\RsIntl
14:23:13 SQLProg\SQLServr\ActiveX
14:23:13 SQLProg\SQLServr\System
14:23:13 SQLProg\UpgTools
14:23:13 SQLProg\UpgTools\UpgSys
14:23:13 SQLProg\UpgTools\ActiveX
14:23:13 SQLProg\UpgTools\Res1033
14:23:13 SQLProg\UpgTools\ResOther
14:23:13 SQLProg\UpgTools\Resld
14:23:13 SQLProg\ReplSupp
14:23:13 SQLProg\ReplSupp\ReplDat
14:23:13 SQLProg\ReplSupp\RepComm
14:23:13 SQLProg\ReplSupp\RepNoDk
14:23:13 SQLProg\ReplSupp\ActiveX
14:23:13 SQLProg\Install
14:23:13 SQLProg\System
14:23:13 SQLProg\SvrExt
14:23:13 SQLProg\SvrExt\Help
14:23:13 SQLProg\SvrExt\SvrExtRs
14:23:13 SQLProg\SvrExt\ResIntl
14:23:13 SQLProg\Dat
14:23:13 SQLProg\DatSmpl
14:23:13 SQLProg\BaseSys
14:23:13 SQLProg\BaseBinn
14:23:13 SQLProg\BaseInst
14:23:13 SQLProg\Symbols
14:23:13 SQLProg\Symbols\EXE
14:23:13 SQLProg\Symbols\DLL
14:23:13 SQLProg\Perfmon
14:23:13 SQLProg\Perfmon\System
14:23:13 SQLProg\Root
14:23:13 MgtTool
14:23:13 MgtTool\SEM
14:23:13 MgtTool\SEM\HTML
14:23:13 MgtTool\SEM\MSD98
14:23:13 MgtTool\SEM\MSD98SYS
14:23:13 MgtTool\SEM\MSD98Res
14:23:13 MgtTool\SEM\MSD98Hlp
14:23:13 MgtTool\SEM\Help
14:23:13 MgtTool\SEM\Res1033
14:23:13 MgtTool\SEM\ResIntl
14:23:13 MgtTool\SEM\MSD98RsI
14:23:13 MgtTool\SEM\ActiveX
14:23:13 MgtTool\SEM\ActiveX\Res1033
14:23:13 MgtTool\SEM\ActiveX\ResIntl
14:23:13 MgtTool\SEM\Scripts
14:23:13 MgtTool\SEM\OLEDB
14:23:13 MgtTool\SEM\OLEDB\Res1033
14:23:13 MgtTool\SEM\OLEDB\ResIntl
14:23:13 MgtTool\Profiler
14:23:13 MgtTool\Profiler\Help
14:23:13 MgtTool\Profiler\Res1033
14:23:13 MgtTool\Profiler\ResIntl
14:23:13 MgtTool\Qryanlz
14:23:13 MgtTool\Qryanlz\Help
14:23:13 MgtTool\Qryanlz\Res1033
14:23:13 MgtTool\Qryanlz\ResIntl
14:23:13 MgtTool\DTCCLi
14:23:13 MgtTool\Wzcnflct
14:23:13 MgtTool\Wzcnflct\WzcnHlp
14:23:13 MgtTool\Wzcnflct\Wzcn1033
14:23:13 MgtTool\Wzcnflct\WzcnOthr
14:23:13 MgtTool\Wzcnflct\WzcnCmn
14:23:13 MgtTool\UtilSys
14:23:13 MgtTool\UtilBinn
14:23:13 Connect
14:23:13 Connect\ConnSys
14:23:13 Books
14:23:13 Books\Bookso
14:23:13 Books\Bookso\Utils
14:23:13 DevTools
14:23:13 DevTools\Dbg Int
14:23:13 DevTools\Dbg Int\Dbg Int Common
14:23:13 DevTools\Dbg Int\EXE
14:23:13 CoreRepl
14:23:13 CoreRepl\Res1033
14:23:13 CoreRepl\ResIntl
14:23:13 Core
14:23:13 Core\Res1033
14:23:13 Core\ResOther
14:23:13 Repostry
14:23:13 Repostry\RepstSys
14:23:13 Repostry\Res1033
14:23:13 Repostry\ResIntl
14:23:13 CoreMisc
14:23:13 CoreMisc\ActiveX
14:23:13 CoreMisc\ActiveX\Res1033
14:23:13 CoreMisc\ActiveX\ResIntl
14:23:13 CoreMisc\Res1033
14:23:13 Monarch
14:23:13 Monarch\Monr1033
14:23:13 Monarch\MonrIntl
14:23:13 Jet
14:23:13 CoreInst
14:23:13 CoreCOM
14:23:13 CoreCOM\Res1033
14:23:13 CoreCOM\ResIntl
14:23:13 CoreTool
14:23:13 CoreTool\Res1033
14:23:13 CoreTool\ResOther
14:23:13 DBLibCli
14:23:13 SFExt
14:23:13 SFExt\ActiveX
14:23:13 SFExt\ActiveX\Res1033
14:23:13 SFExt\ActiveX\ResIntl
14:23:13 SFExt\Res1033
14:23:13 SFExt\ResIntl
14:23:13 Trace
14:23:13 Trace\Res1033
14:23:13 Trace\ResOther
14:23:13 MiscCore
14:23:13 MC
14:23:13 MC\MC1033
14:23:13 MC\MCIntl
14:23:13 MC\Help
14:23:13 SQLMgr
14:23:13 SQLMgr\Res1033
14:23:13 SQLMgr\ResIntl
14:23:13 SvrTool
14:23:13 SvrTool\Res1033
14:23:13 SvrTool\ResIntl
14:23:13 DTSUI
14:23:13 DTSUI\Res1033
14:23:13 DTSUI\ResIntl
14:23:13 MSOlap
14:23:13 MSOlap\Res1033
14:23:13 MSOlap\ResIntl
14:23:13 ATL
14:23:13 ATL\winnt
14:23:13 ATL\win9x
14:23:13 MFC42U
14:23:13 VC
14:23:13 VB
14:23:13 OCX1
14:23:13 SQLAdHlp
14:23:13 SQLAdHlp\Res1033
14:23:13 SQLAdHlp\ResOther
14:23:13 {E07FDDBE-5A21-11d2-9DAD-00C04F79D434}
14:23:13 {E07FDDC7-5A21-11d2-9DAD-00C04F79D434}
14:23:13 {E07FDDC0-5A21-11d2-9DAD-00C04F79D434}
14:23:13 {E07FDDBF-5A21-11d2-9DAD-00C04F79D434}
14:23:13 End Action LogSelectedComponents
14:23:13 Begin Action InstallPkgs:
14:23:13 Begin Action: Locked Connectivity Files Check
14:23:13 ConnectivityLocked returned: 0
14:23:13 Der Vorgang wurde erfolgreich beendet.

14:23:13 End Action: Locked Connectivity Files Check
14:23:13 Setup is installing Microsoft Data Access Components (MDAC)
...
14:23:13 E:\SOFTWA~1\DEV\DB\SQL200~1\x86\Other\sqlredis.exe /q:a
/C:"setupre.exe WARN=1 -s -SMS"
14:23:24 ExitCode: 0
14:23:24 Setup is installing Microsoft Distributed Transaction
Coordinator (MSDTC) ...
14:23:24 C:\WINDOWS\TEMP\SqlSetup\Bin\cldtcstp.exe -SupportDir
"C:\WINDOWS\TEMP\SqlSetup\Bin" -DTCPkg
"E:\SOFTWA~1\DEV\DB\SQL200~1\x86\Other\dtcsetup.exe" -LogFile
"C:\WINDOWS\sqlstp.log"
14:23:24 Process Exit Code: (0)
14:23:24 /Q:A /T:C:\WINDOWS\TEMP\ixp001.tmp
14:23:24 Setup is installing HTML Help ...
14:23:24 HTML Help installer exit code: 0
14:23:45 End Action InstallPkgs
14:23:45 Begin Action MoveFileData:
14:23:45 Enabled SELFREGISTERBATCH
14:23:45 Enabled CORECOMPONENTHANDLING
14:24:11 Begin Action: MoveFileDataSpecial
14:24:11 End Action: MoveFileDataSpecial
14:24:11 End Action MoveFileData
14:24:11 Begin Action ProcessAfterDataMove:
14:24:11 E:\SOFTWA~1\DEV\DB\SQL200~1\x86\Binn\hhcol.exe
C:\Programme\Microsoft SQL Server\80\Tools\Books
14:24:11 End Action ProcessAfterDataMove
14:24:11 Begin Action BuildServer:
14:24:11 C:\WINDOWS\TEMP\SqlSetup\Bin\scm.exe -Silent 1 -Action 5
-ExePath "C:\Programme\Microsoft SQL Server\MSSQL\binn\sqlservr.exe"
-Service "MSSQLSERVER"
14:24:12 Process Exit Code: (0)
14:24:12 Begin Action: CreateRegistrySetSQL
14:24:12 End Action: CreateRegistrySetSQL
14:24:12 Begin Action: RegWriteSetupEntry
14:24:12 End Action: RegWriteSetupEntry
14:24:12 Begin Action: CreateSer
14:24:12 End Action: CreateSer
14:24:12 Begin Action: SkuIt
14:24:12 End Action: SkuIt
14:24:12 SetFileSecuritySQLAndAdmin for C:\Programme\Microsoft SQL
Server\MSSQL returned: 0, 0
14:24:12 SetRegSecuritySQLAndAdmin for
Software\Microsoft\MSSQLServer\MSSQLServer returned: 0, 0
14:24:12 Begin Action: UpdateSystemPath
14:24:12 Path successfully updated.
14:24:12
%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;C:\Programme\­Java\jdk1.5.0_04\bin;C:\Borland\BCC55\bin;"C:\Programme\Symantec\Norton
Ghost 2003\";C:\Programme\Microsoft SQL
Server\80\Tools\BINN;C:\Programme\MySQL\MySQL Server 5.0\bin
14:24:12 End Action: UpdateSystemPath
14:24:13 C:\Programme\Microsoft SQL Server\80\Tools\Binn\cnfgsvr.exe
-F "C:\WINDOWS\sqlstp.log" -I MSSQLSERVER -V 1 -M 0 -Q "Arabic_CI_AS"
-H 459924 -U sa -P
###########################################################################­####

Starting Service ...

Arabic_CI_AS

-m -Q -T4022 -T3659

Connecting to Server ...

driver={sql server};server=COOSA;UID=sa;PWD=;database=master

Configuring Server ...

EXEC sp_grantlogin N'VORDEFINIERT\Administratoren'

[Microsoft][ODBC SQL Server Driver][SQL Server]Granted login access to
'VORDEFINIERT\Administratoren'.

EXEC sp_addsrvrolemember N'VORDEFINIERT\Administratoren', 'sysadmin'

[Microsoft][ODBC SQL Server Driver][SQL
Server]'VORDEFINIERT\Administratoren' added to role 'sysadmin'.

update master.dbo.spt_server_info set attribute_value = @.@.version where
attribute_id = 2

EXEC sp_addserver N'COOSA', local

EXEC sp_configure 'allow updates', 1

[Microsoft][ODBC SQL Server Driver][SQL Server]DBCC execution
completed. If DBCC printed error messages, contact your system
administrator.

[Microsoft][ODBC SQL Server Driver][SQL Server]Configuration option
'allow updates' changed from 0 to 1. Run the RECONFIGURE statement to
install.

reconfigure with override

update master.dbo.sysaltfiles set size=1024 where name=N'tempdev'

EXEC sp_configure 'allow updates', 0

[Microsoft][ODBC SQL Server Driver][SQL Server]DBCC execution
completed. If DBCC printed error messages, contact your system
administrator.

[Microsoft][ODBC SQL Server Driver][SQL Server]Configuration option
'allow updates' changed from 1 to 0. Run the RECONFIGURE statement to
install.

reconfigure with override

Disconnecting from Server ...

Stopping Service ...

SQL Server has been successfully configured!

###########################################################################­####

14:24:42 Process Exit Code: (0)
14:24:42 End Action BuildServer
14:24:42 Begin Action SelfRegiser
14:24:42 DLLRegisterServer atl.dll: 0, 0x0
14:24:50 Return code: 0
14:24:50 Begin Action SelfRegisterOnCluster
14:24:50 End Action SelfRegisterOnCluster
14:24:50 Begin Action RegisterSvrReplFiles
14:24:50 **** File registered: C:\Programme\Microsoft SQL
Server\80\COM\snapshot.exe-unregserver
14:24:50 **** File registered: C:\Programme\Microsoft SQL
Server\80\COM\distrib.exe-unregserver
14:24:50 **** File registered: C:\Programme\Microsoft SQL
Server\80\COM\replmerg.exe-unregserver
14:24:50 **** File registered: C:\Programme\Microsoft SQL
Server\80\COM\logread.exe-unregserver
14:24:50 **** File registered: C:\Programme\Microsoft SQL
Server\80\COM\qrdrsvc.exe-unregserver
14:24:51 **** File registered: C:\Programme\Microsoft SQL
Server\80\COM\snapshot.exe-regserver
14:24:51 **** File registered: C:\Programme\Microsoft SQL
Server\80\COM\distrib.exe-regserver
14:24:51 **** File registered: C:\Programme\Microsoft SQL
Server\80\COM\replmerg.exe-regserver
14:24:51 **** File registered: C:\Programme\Microsoft SQL
Server\80\COM\logread.exe-regserver
14:24:51 **** File registered: C:\Programme\Microsoft SQL
Server\80\COM\qrdrsvc.exe-regserver
14:24:51 End Action RegisterSvrReplFiles
14:24:51 Begin Action SelfRegisterCOMShared
14:24:51 End Action SelfRegisterCOMShared
14:24:51 End Action SelfRegister
14:24:51 Begin Action SetupRegistry:
14:24:51 SNMP service has been detected.
14:24:51 Begin Action RegWriteInstalledInstances:
14:24:51 End Action RegWriteInstalledInstances
14:24:51 Register this installation of SQL Server with MDAC
14:24:51 Completed registering this installation of SQL Server with
MDAC
14:25:07 An error occurred while creating one or more registry entries.
Please see C:\WINDOWS\\\sqlstp.log for details. The problem could be
caused by a low registry quota condition.
14:25:07 Action CleanUpInstall:
14:25:07 C:\WINDOWS\TEMP\SqlSetup\Bin\scm.exe -Silent 1 -Action 4
-Service SQLSERVERAGENT
14:25:07 Process Exit Code: (1060) Der angegebene Dienst ist kein
installierter Dienst.

14:25:07 C:\WINDOWS\TEMP\SqlSetup\Bin\scm.exe -Silent 1 -Action 4
-Service MSSQLSERVER
14:25:07 Process Exit Code: (0)
14:25:07 StatsGenerate returned: 2
14:25:07 StatsGenerate
(0x80000000,0x1,0xf000000,0x200,1033,303,0x0,0x1,0,0,0
14:25:07 StatsGenerate -1,admin)
14:25:07 Installation Failed.

I got the indentical error when I attempted to install SQL 2000 Developer's Edition on XP Pro. My log file failure occurred at the same place yours did.

I had recently installed .Net framework, .Net SDK, and ASP Web Matrix. I made a lucky guess that they were causing the problem.

I did an uninstall of:
.Net framework
.Net SDK
ASP Web Matrix

I deleted the sub folders in c:\Program Files\Microsoft SQL Server.

Then SQL 2000 DE installed successfully, and I reinstalled the .Net framework & ASP Web Matrix.

Hope this helps.

Frustrating Installation Error

I was installing SQL Server on my machine and during installation my PC
freezed. It happens frequently on my machine as my bad luck sticks frequenctly to my side. So i tried after
restarting to install it again and since then i always get the same
error message:
"An error occurred while creating one or more registry entries. Please
see C:\WINDOWS\sqlstp.log for details. The problem could be caused by a
low registry quota condition"
I have tried to clean the registry during the installation bt chosing "advanced options" -> "Rebuild registry" and i don't know what else i could
do to solve this issue. I'd like to remark that i also deleted the SQL Server keys from Registry as suggested from Microsoft to delete default and special named instances.

I also deleted every thing under %TEMP%; I even installed third pary registry tools to clean the registry such as RegistryFix, Registry Mechanic and AMUST.

Finally, i'm using Windows XP Professional SP2.

Any help?

The log file lists the following:

14:22:27 Begin Setup
14:22:27 8.00.194
14:22:27 Mode = Normal
14:22:27 ModeType = NORMAL
14:22:27 GetDefinitionEx returned: 0, Extended: 0x0
14:22:27 ValueFTS returned: 1
14:22:27 ValuePID returned: 1
14:22:27 ValueLic returned: 0
14:22:27 System: Windows NT WorkStation
14:22:27 SQL Server ProductType: Developer Edition [0x3]
14:22:27 Begin Action: SetupInitialize
14:22:27 End Action SetupInitialize
14:22:27 Begin Action: SetupInstall
14:22:27 Reading
Software\Microsoft\Windows\CurrentVersion\CommonFilesDir ...
14:22:27 CommonFilesDir=C:\Programme\Gemeinsame Dateien
14:22:27 Windows Directory=C:\WINDOWS\
14:22:27 Program Files=C:\Programme\
14:22:27 TEMPDIR=C:\WINDOWS\TEMP\
14:22:27 Begin Action: SetupInstall
14:22:27 digpid size : 256
14:22:27 digpid size : 164
14:22:27 Begin Action: CheckFixedRequirements
14:22:27 Platform ID: 0xf000000
14:22:27 Version: 5.1.2600
14:22:27 File Version - C:\WINDOWS\system32\shdocvw.dll: 6.0.2900.2805
14:22:27 End Action: CheckFixedRequirements
14:22:27 Begin Action: ShowDialogs
14:22:27 Initial Dialog Mask: 0x83000f7, Disable Back=0x1
14:22:27 Begin Action ShowDialogsHlpr: 0x1
14:22:27 Begin Action: DialogShowSdWelcome
14:22:28 End Action DialogShowSdWelcome
14:22:28 Dialog 0x1 returned: 1
14:22:28 End Action ShowDialogsHlpr
14:22:28 ShowDialogsGetDialog returned: nCurrent=0x2,index=1
14:22:28 Begin Action ShowDialogsHlpr: 0x2
14:22:28 Begin Action: DialogShowSdMachineName
14:22:30 ShowDlgMachine returned: 1
14:22:30 Name = COOSA, Type = 0x1
14:22:30 Begin Action: CheckRequirements
14:22:30 Processor Architecture: x86 (Pentium)
14:22:30 Service Pack: 512
14:22:30 ComputerName: COOSA
14:22:30 User Name: admin
14:22:30 IsAllAccessAllowed returned: 1
14:22:30 OS Language: 0x401
14:22:30 End Action CheckRequirements
14:22:30 This combination of Package and Operating System allows a full
product install.
14:22:30 CreateSetupTopology(COOSA), Handle : 0x1b04098, returned : 0
14:22:30 CreateSetupTopology returned : 0, Handle : 0x1b04098
14:22:30 Topology Type : 1, Return Value : 0
14:22:30 ST_GetPhysicalNode returned : 0, PNHandle : 0x1b040c0
14:22:30 PN_EnumerateEx returned : 0
14:22:30 PN_GetSQLStates returned : 0, SqlStates : 0x80000000
14:22:30 PN_StartScan [0x1b040c0] returned : 0
14:22:30 PN_GetNext [0x1b040c0] returned : 18, Handle: [0x0]
14:22:30 No more items in enumeration.
14:22:30 ReleaseSetupTopology
14:22:30 Named instance limit: 100, quota: 0
14:22:30 End Action DialogShowSdMachineName
14:22:30 begin ShowDialogsUpdateMask
14:22:30 nFullMask = 0x83000f7, nCurrent = 0x2, nDirection = 0
14:22:30 Updated Dialog Mask: 0xbf00037, Disable Back = 0x1
14:22:30 Dialog 0x2 returned: 0
14:22:30 End Action ShowDialogsHlpr
14:22:30 ShowDialogsGetDialog returned: nCurrent=0x4,index=2
14:22:30 Begin Action ShowDialogsHlpr: 0x4
14:22:30 Begin Action: DialogShowSdInstallMode
14:22:36 ShowDlgInstallMode returned: 1
14:22:36 InstallMode : 0x1
14:22:36 End Action DialogShowSdInstallMode
14:22:36 begin ShowDialogsUpdateMask
14:22:36 nFullMask = 0xbf00037, nCurrent = 0x4, nDirection = 1
14:22:36 Updated Dialog Mask: 0xbf40037, Disable Back = 0x1
14:22:36 Dialog 0x4 returned: 1
14:22:36 End Action ShowDialogsHlpr
14:22:36 ShowDialogsGetDialog returned: nCurrent=0x10,index=4
14:22:36 Begin Action ShowDialogsHlpr: 0x10
14:22:36 Begin Action: DialogShowSdRegisterUserEx
14:22:42 End Action DialogShowSdRegisterUserEx
14:22:42 Dialog 0x10 returned: 1
14:22:42 End Action ShowDialogsHlpr
14:22:42 ShowDialogsGetDialog returned: nCurrent=0x20,index=5
14:22:42 Begin Action ShowDialogsHlpr: 0x20
14:22:42 Begin Action: DialogShowSdLicense
14:22:43 End Action DialogShowSdLicense
14:22:43 Dialog 0x20 returned: 1
14:22:43 End Action ShowDialogsHlpr
14:22:43 ShowDialogsGetDialog returned: nCurrent=0x40000,index=18
14:22:43 Begin Action ShowDialogsHlpr: 0x40000
14:22:43 Begin Action: DialogShowSdCliSvr
14:22:43 DisplaySystemPreReq
14:22:45 ShowDlgClientServerSelect returned: 1
14:22:45 Type : 0x2
14:22:45 End Action DialogShowSdCliSvr
14:22:45 begin ShowDialogsUpdateMask
14:22:45 nFullMask = 0xbf40037, nCurrent = 0x40000, nDirection = 1
14:22:45 Updated Dialog Mask: 0xbfc0037, Disable Back = 0x1
14:22:45 Dialog 0x40000 returned: 1
14:22:45 End Action ShowDialogsHlpr
14:22:45 ShowDialogsGetDialog returned: nCurrent=0x80000,index=19
14:22:45 Begin Action ShowDialogsHlpr: 0x80000
14:22:45 Begin Action: DialogShowSdInstanceName
14:22:45 Begin Action: ShowDlgInstanceName
14:22:47 End Action: ShowDlgInstanceName
14:22:47 ShowDlgInstanceName returned : 1
14:22:47 InstanceName : MSSQLSERVER
14:22:47 CreateSetupTopology(COOSA), Handle : 0x1b04098, returned : 0
14:22:47 CreateSetupTopology returned : 0, Handle : 0x1b04098
14:22:47 Topology Type : 1, Return Value : 0
14:22:47 ST_GetPhysicalNode returned : 0, PNHandle : 0x1b040c0
14:22:47 PN_EnumerateEx returned : 0
14:22:47 PN_GetSQLStates returned : 0, SqlStates : 0x80000000
14:22:47 PN_StartScan [0x1b040c0] returned : 0
14:22:47 PN_GetNext [0x1b040c0] returned : 18, Handle: [0x0]
14:22:47 No more items in enumeration.
14:22:47 ReleaseSetupTopology
14:22:47 End Action DialogShowSdInstanceName
14:22:47 begin ShowDialogsUpdateMask
14:22:47 nFullMask = 0xbfc0037, nCurrent = 0x80000, nDirection = 1
14:22:47 Updated Dialog Mask: 0xbfc0037, Disable Back = 0x1
14:22:47 Dialog 0x80000 returned: 1
14:22:47 End Action ShowDialogsHlpr
14:22:47 ShowDialogsGetDialog returned: nCurrent=0x100000,index=20
14:22:47 Begin Action ShowDialogsHlpr: 0x100000
14:22:47 Begin Action: DialogShowSdSetupType
14:22:47 Begin Action: Setup Type
14:23:05 SQL program folder: C:\Programme\Microsoft SQL Server
14:23:05 SQL data folder: C:\Programme\Microsoft SQL Server
14:23:05 Windows system folder: C:\WINDOWS\system32\
14:23:05 Prog req: 38073, Data req: 34432, Sys req: 158694
14:23:05 Prog avail: 1481708, Data avail: 1481708, Sys avail: 1481708
14:23:05 Prog req vs. avail, 231199, 1481708
14:23:05 Data req vs. avail, 34432, 1481708
14:23:05 Sys req vs. avail, 193126, 1481708
14:23:05 DisplaySystemPreReq
14:23:05 [SetupTypeSQL]
14:23:05 szDir = C:\Programme\Microsoft SQL Server
14:23:05 szDir = %PROGRAMFILES%\Microsoft SQL Server
14:23:05 Result = 301
14:23:05 szDataDir = C:\Programme\Microsoft SQL Server
14:23:05 szDataDir = %PROGRAMFILES%\Microsoft SQL Server
14:23:05 End Action: Setup Type
14:23:05 Setup Type: Typical (301)
14:23:05 End Action DialogShowSdSetupType
14:23:05 begin ShowDialogsUpdateMask
14:23:05 nFullMask = 0xbfc0037, nCurrent = 0x100000, nDirection = 301
14:23:05 Updated Dialog Mask: 0xbdc0037, Disable Back = 0x1
14:23:05 Dialog 0x100000 returned: 301
14:23:05 End Action ShowDialogsHlpr
14:23:05 ShowDialogsGetDialog returned: nCurrent=0x400000,index=22
14:23:05 Begin Action ShowDialogsHlpr: 0x400000
14:23:05 Begin Action: DlgServices
14:23:10 ShowDlgServices returned: 1
14:23:10 [DlgServices]
14:23:10 Local-Domain = 3855
14:23:10 AutoStart = 15
14:23:10 Result = 1
14:23:10 End Action DlgServices
14:23:10 begin ShowDialogsUpdateMask
14:23:10 nFullMask = 0xbdc0037, nCurrent = 0x400000, nDirection = 1
14:23:10 Updated Dialog Mask: 0xbdc0037, Disable Back = 0x1
14:23:10 Dialog 0x400000 returned: 1
14:23:10 End Action ShowDialogsHlpr
14:23:10 ShowDialogsGetDialog returned: nCurrent=0x800000,index=23
14:23:10 Begin Action ShowDialogsHlpr: 0x800000
14:23:10 Begin Action: DlgSQLSecurity
14:23:12 ShowDlgSQLSecurity returned: 1
14:23:12 LoginMode = 1,szPwd
14:23:12 End Action DlgSQLSecurity
14:23:12 begin ShowDialogsUpdateMask
14:23:12 nFullMask = 0xbdc0037, nCurrent = 0x800000, nDirection = 1
14:23:12 Updated Dialog Mask: 0xbdc0037, Disable Back = 0x1
14:23:12 Dialog 0x800000 returned: 1
14:23:12 End Action ShowDialogsHlpr
14:23:12 ShowDialogsGetDialog returned: nCurrent=0x1000000,index=24
14:23:12 Begin Action ShowDialogsHlpr: 0x1000000
14:23:12 Begin Action: DlgCollation
14:23:12 ShowDlgCollation returned: 1
14:23:12 collation_name = Arabic_CI_AS,locale_name = Arabic,lcid =
0x401,SortId = 0,dwCompFlags = 0x30001
14:23:12 End Action DlgCollation
14:23:12 begin ShowDialogsUpdateMask
14:23:12 nFullMask = 0xbdc0037, nCurrent = 0x1000000, nDirection = 1
14:23:12 Updated Dialog Mask: 0xbdc0037, Disable Back = 0x1
14:23:12 Dialog 0x1000000 returned: 1
14:23:12 End Action ShowDialogsHlpr
14:23:12 ShowDialogsGetDialog returned: nCurrent=0x2000000,index=25
14:23:12 Begin Action ShowDialogsHlpr: 0x2000000
14:23:12 Begin Action: DlgNetwork
14:23:12 ShowDlgNetwork returned: 1
14:23:12 [DlgServerNetwork]
14:23:12 NetworkLibs = 255
14:23:12 TCPPort = 1433
14:23:12 TCPPrxy = Default
14:23:12 NMPPipeName = \\.\pipe\sql\query
14:23:12 Result = 1
14:23:12 End Action DlgNetwork
14:23:12 begin ShowDialogsUpdateMask
14:23:12 nFullMask = 0xbdc0037, nCurrent = 0x2000000, nDirection = 1
14:23:12 Updated Dialog Mask: 0xbdc0037, Disable Back = 0x1
14:23:12 Dialog 0x2000000 returned: 1
14:23:12 End Action ShowDialogsHlpr
14:23:12 ShowDialogsGetDialog returned: nCurrent=0x8000000,index=27
14:23:12 Begin Action ShowDialogsHlpr: 0x8000000
14:23:12 Begin Action: DialogShowSdStartCopy
14:23:13 End Action DialogShowSdStartCopy
14:23:13 begin ShowDialogsUpdateMask
14:23:13 nFullMask = 0xbdc0037, nCurrent = 0x8000000, nDirection = 1
14:23:13 Updated Dialog Mask: 0xbdc0037, Disable Back = 0x1
14:23:13 Dialog 0x8000000 returned: 1
14:23:13 End Action ShowDialogsHlpr
14:23:13 ShowDialogsGetDialog returned: nCurrent=0x0,index=0
14:23:13 End Action ShowDialogs
14:23:13 Begin Action ProcessBeforeDataMove:
14:23:13 DeinstallStart returned (C:\Programme\Microsoft SQL
Server\MSSQL): 0
14:23:13 End Action ProcessBeforeDataMove:
14:23:13 Begin Action SetToolsComponentSelection:
14:23:13 End Action SetToolsComponentSelection:
14:23:13 Begin Action ProcessComponentSelection:
14:23:13 End Action ProcessComponentSelection
14:23:13 Begin Action LogSelectedComponents:
14:23:13 SQLProg
14:23:13 SQLProg\SQLServr
14:23:13 SQLProg\SQLServr\Help
14:23:13 SQLProg\SQLServr\SCMDev
14:23:13 SQLProg\SQLServr\SCMDev\SCMh
14:23:13 SQLProg\SQLServr\SCMDev\SCMX86Lb
14:23:13 SQLProg\SQLServr\SCMDev\SCMALb
14:23:13 SQLProg\SQLServr\Rs1033
14:23:13 SQLProg\SQLServr\RsIntl
14:23:13 SQLProg\SQLServr\ActiveX
14:23:13 SQLProg\SQLServr\System
14:23:13 SQLProg\UpgTools
14:23:13 SQLProg\UpgTools\UpgSys
14:23:13 SQLProg\UpgTools\ActiveX
14:23:13 SQLProg\UpgTools\Res1033
14:23:13 SQLProg\UpgTools\ResOther
14:23:13 SQLProg\UpgTools\Resld
14:23:13 SQLProg\ReplSupp
14:23:13 SQLProg\ReplSupp\ReplDat
14:23:13 SQLProg\ReplSupp\RepComm
14:23:13 SQLProg\ReplSupp\RepNoDk
14:23:13 SQLProg\ReplSupp\ActiveX
14:23:13 SQLProg\Install
14:23:13 SQLProg\System
14:23:13 SQLProg\SvrExt
14:23:13 SQLProg\SvrExt\Help
14:23:13 SQLProg\SvrExt\SvrExtRs
14:23:13 SQLProg\SvrExt\ResIntl
14:23:13 SQLProg\Dat
14:23:13 SQLProg\DatSmpl
14:23:13 SQLProg\BaseSys
14:23:13 SQLProg\BaseBinn
14:23:13 SQLProg\BaseInst
14:23:13 SQLProg\Symbols
14:23:13 SQLProg\Symbols\EXE
14:23:13 SQLProg\Symbols\DLL
14:23:13 SQLProg\Perfmon
14:23:13 SQLProg\Perfmon\System
14:23:13 SQLProg\Root
14:23:13 MgtTool
14:23:13 MgtTool\SEM
14:23:13 MgtTool\SEM\HTML
14:23:13 MgtTool\SEM\MSD98
14:23:13 MgtTool\SEM\MSD98SYS
14:23:13 MgtTool\SEM\MSD98Res
14:23:13 MgtTool\SEM\MSD98Hlp
14:23:13 MgtTool\SEM\Help
14:23:13 MgtTool\SEM\Res1033
14:23:13 MgtTool\SEM\ResIntl
14:23:13 MgtTool\SEM\MSD98RsI
14:23:13 MgtTool\SEM\ActiveX
14:23:13 MgtTool\SEM\ActiveX\Res1033
14:23:13 MgtTool\SEM\ActiveX\ResIntl
14:23:13 MgtTool\SEM\Scripts
14:23:13 MgtTool\SEM\OLEDB
14:23:13 MgtTool\SEM\OLEDB\Res1033
14:23:13 MgtTool\SEM\OLEDB\ResIntl
14:23:13 MgtTool\Profiler
14:23:13 MgtTool\Profiler\Help
14:23:13 MgtTool\Profiler\Res1033
14:23:13 MgtTool\Profiler\ResIntl
14:23:13 MgtTool\Qryanlz
14:23:13 MgtTool\Qryanlz\Help
14:23:13 MgtTool\Qryanlz\Res1033
14:23:13 MgtTool\Qryanlz\ResIntl
14:23:13 MgtTool\DTCCLi
14:23:13 MgtTool\Wzcnflct
14:23:13 MgtTool\Wzcnflct\WzcnHlp
14:23:13 MgtTool\Wzcnflct\Wzcn1033
14:23:13 MgtTool\Wzcnflct\WzcnOthr
14:23:13 MgtTool\Wzcnflct\WzcnCmn
14:23:13 MgtTool\UtilSys
14:23:13 MgtTool\UtilBinn
14:23:13 Connect
14:23:13 Connect\ConnSys
14:23:13 Books
14:23:13 Books\Bookso
14:23:13 Books\Bookso\Utils
14:23:13 DevTools
14:23:13 DevTools\Dbg Int
14:23:13 DevTools\Dbg Int\Dbg Int Common
14:23:13 DevTools\Dbg Int\EXE
14:23:13 CoreRepl
14:23:13 CoreRepl\Res1033
14:23:13 CoreRepl\ResIntl
14:23:13 Core
14:23:13 Core\Res1033
14:23:13 Core\ResOther
14:23:13 Repostry
14:23:13 Repostry\RepstSys
14:23:13 Repostry\Res1033
14:23:13 Repostry\ResIntl
14:23:13 CoreMisc
14:23:13 CoreMisc\ActiveX
14:23:13 CoreMisc\ActiveX\Res1033
14:23:13 CoreMisc\ActiveX\ResIntl
14:23:13 CoreMisc\Res1033
14:23:13 Monarch
14:23:13 Monarch\Monr1033
14:23:13 Monarch\MonrIntl
14:23:13 Jet
14:23:13 CoreInst
14:23:13 CoreCOM
14:23:13 CoreCOM\Res1033
14:23:13 CoreCOM\ResIntl
14:23:13 CoreTool
14:23:13 CoreTool\Res1033
14:23:13 CoreTool\ResOther
14:23:13 DBLibCli
14:23:13 SFExt
14:23:13 SFExt\ActiveX
14:23:13 SFExt\ActiveX\Res1033
14:23:13 SFExt\ActiveX\ResIntl
14:23:13 SFExt\Res1033
14:23:13 SFExt\ResIntl
14:23:13 Trace
14:23:13 Trace\Res1033
14:23:13 Trace\ResOther
14:23:13 MiscCore
14:23:13 MC
14:23:13 MC\MC1033
14:23:13 MC\MCIntl
14:23:13 MC\Help
14:23:13 SQLMgr
14:23:13 SQLMgr\Res1033
14:23:13 SQLMgr\ResIntl
14:23:13 SvrTool
14:23:13 SvrTool\Res1033
14:23:13 SvrTool\ResIntl
14:23:13 DTSUI
14:23:13 DTSUI\Res1033
14:23:13 DTSUI\ResIntl
14:23:13 MSOlap
14:23:13 MSOlap\Res1033
14:23:13 MSOlap\ResIntl
14:23:13 ATL
14:23:13 ATL\winnt
14:23:13 ATL\win9x
14:23:13 MFC42U
14:23:13 VC
14:23:13 VB
14:23:13 OCX1
14:23:13 SQLAdHlp
14:23:13 SQLAdHlp\Res1033
14:23:13 SQLAdHlp\ResOther
14:23:13 {E07FDDBE-5A21-11d2-9DAD-00C04F79D434}
14:23:13 {E07FDDC7-5A21-11d2-9DAD-00C04F79D434}
14:23:13 {E07FDDC0-5A21-11d2-9DAD-00C04F79D434}
14:23:13 {E07FDDBF-5A21-11d2-9DAD-00C04F79D434}
14:23:13 End Action LogSelectedComponents
14:23:13 Begin Action InstallPkgs:
14:23:13 Begin Action: Locked Connectivity Files Check
14:23:13 ConnectivityLocked returned: 0
14:23:13 Der Vorgang wurde erfolgreich beendet.

14:23:13 End Action: Locked Connectivity Files Check
14:23:13 Setup is installing Microsoft Data Access Components (MDAC)
...
14:23:13 E:\SOFTWA~1\DEV\DB\SQL200~1\x86\Other\sqlredis.exe /q:a
/C:"setupre.exe WARN=1 -s -SMS"
14:23:24 ExitCode: 0
14:23:24 Setup is installing Microsoft Distributed Transaction
Coordinator (MSDTC) ...
14:23:24 C:\WINDOWS\TEMP\SqlSetup\Bin\cldtcstp.exe -SupportDir
"C:\WINDOWS\TEMP\SqlSetup\Bin" -DTCPkg
"E:\SOFTWA~1\DEV\DB\SQL200~1\x86\Other\dtcsetup.exe" -LogFile
"C:\WINDOWS\sqlstp.log"
14:23:24 Process Exit Code: (0)
14:23:24 /Q:A /T:C:\WINDOWS\TEMP\ixp001.tmp
14:23:24 Setup is installing HTML Help ...
14:23:24 HTML Help installer exit code: 0
14:23:45 End Action InstallPkgs
14:23:45 Begin Action MoveFileData:
14:23:45 Enabled SELFREGISTERBATCH
14:23:45 Enabled CORECOMPONENTHANDLING
14:24:11 Begin Action: MoveFileDataSpecial
14:24:11 End Action: MoveFileDataSpecial
14:24:11 End Action MoveFileData
14:24:11 Begin Action ProcessAfterDataMove:
14:24:11 E:\SOFTWA~1\DEV\DB\SQL200~1\x86\Binn\hhcol.exe
C:\Programme\Microsoft SQL Server\80\Tools\Books
14:24:11 End Action ProcessAfterDataMove
14:24:11 Begin Action BuildServer:
14:24:11 C:\WINDOWS\TEMP\SqlSetup\Bin\scm.exe -Silent 1 -Action 5
-ExePath "C:\Programme\Microsoft SQL Server\MSSQL\binn\sqlservr.exe"
-Service "MSSQLSERVER"
14:24:12 Process Exit Code: (0)
14:24:12 Begin Action: CreateRegistrySetSQL
14:24:12 End Action: CreateRegistrySetSQL
14:24:12 Begin Action: RegWriteSetupEntry
14:24:12 End Action: RegWriteSetupEntry
14:24:12 Begin Action: CreateSer
14:24:12 End Action: CreateSer
14:24:12 Begin Action: SkuIt
14:24:12 End Action: SkuIt
14:24:12 SetFileSecuritySQLAndAdmin for C:\Programme\Microsoft SQL
Server\MSSQL returned: 0, 0
14:24:12 SetRegSecuritySQLAndAdmin for
Software\Microsoft\MSSQLServer\MSSQLServer returned: 0, 0
14:24:12 Begin Action: UpdateSystemPath
14:24:12 Path successfully updated.
14:24:12
%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;C:\Programme\­Java\jdk1.5.0_04\bin;C:\Borland\BCC55\bin;"C:\Programme\Symantec\Norton
Ghost 2003\";C:\Programme\Microsoft SQL
Server\80\Tools\BINN;C:\Programme\MySQL\MySQL Server 5.0\bin
14:24:12 End Action: UpdateSystemPath
14:24:13 C:\Programme\Microsoft SQL Server\80\Tools\Binn\cnfgsvr.exe
-F "C:\WINDOWS\sqlstp.log" -I MSSQLSERVER -V 1 -M 0 -Q "Arabic_CI_AS"
-H 459924 -U sa -P
###########################################################################­####

Starting Service ...

Arabic_CI_AS

-m -Q -T4022 -T3659

Connecting to Server ...

driver={sql server};server=COOSA;UID=sa;PWD=;database=master

Configuring Server ...

EXEC sp_grantlogin N'VORDEFINIERT\Administratoren'

[Microsoft][ODBC SQL Server Driver][SQL Server]Granted login access to
'VORDEFINIERT\Administratoren'.

EXEC sp_addsrvrolemember N'VORDEFINIERT\Administratoren', 'sysadmin'

[Microsoft][ODBC SQL Server Driver][SQL
Server]'VORDEFINIERT\Administratoren' added to role 'sysadmin'.

update master.dbo.spt_server_info set attribute_value = @.@.version where
attribute_id = 2

EXEC sp_addserver N'COOSA', local

EXEC sp_configure 'allow updates', 1

[Microsoft][ODBC SQL Server Driver][SQL Server]DBCC execution
completed. If DBCC printed error messages, contact your system
administrator.

[Microsoft][ODBC SQL Server Driver][SQL Server]Configuration option
'allow updates' changed from 0 to 1. Run the RECONFIGURE statement to
install.

reconfigure with override

update master.dbo.sysaltfiles set size=1024 where name=N'tempdev'

EXEC sp_configure 'allow updates', 0

[Microsoft][ODBC SQL Server Driver][SQL Server]DBCC execution
completed. If DBCC printed error messages, contact your system
administrator.

[Microsoft][ODBC SQL Server Driver][SQL Server]Configuration option
'allow updates' changed from 1 to 0. Run the RECONFIGURE statement to
install.

reconfigure with override

Disconnecting from Server ...

Stopping Service ...

SQL Server has been successfully configured!

###########################################################################­####

14:24:42 Process Exit Code: (0)
14:24:42 End Action BuildServer
14:24:42 Begin Action SelfRegiser
14:24:42 DLLRegisterServer atl.dll: 0, 0x0
14:24:50 Return code: 0
14:24:50 Begin Action SelfRegisterOnCluster
14:24:50 End Action SelfRegisterOnCluster
14:24:50 Begin Action RegisterSvrReplFiles
14:24:50 **** File registered: C:\Programme\Microsoft SQL
Server\80\COM\snapshot.exe-unregserver
14:24:50 **** File registered: C:\Programme\Microsoft SQL
Server\80\COM\distrib.exe-unregserver
14:24:50 **** File registered: C:\Programme\Microsoft SQL
Server\80\COM\replmerg.exe-unregserver
14:24:50 **** File registered: C:\Programme\Microsoft SQL
Server\80\COM\logread.exe-unregserver
14:24:50 **** File registered: C:\Programme\Microsoft SQL
Server\80\COM\qrdrsvc.exe-unregserver
14:24:51 **** File registered: C:\Programme\Microsoft SQL
Server\80\COM\snapshot.exe-regserver
14:24:51 **** File registered: C:\Programme\Microsoft SQL
Server\80\COM\distrib.exe-regserver
14:24:51 **** File registered: C:\Programme\Microsoft SQL
Server\80\COM\replmerg.exe-regserver
14:24:51 **** File registered: C:\Programme\Microsoft SQL
Server\80\COM\logread.exe-regserver
14:24:51 **** File registered: C:\Programme\Microsoft SQL
Server\80\COM\qrdrsvc.exe-regserver
14:24:51 End Action RegisterSvrReplFiles
14:24:51 Begin Action SelfRegisterCOMShared
14:24:51 End Action SelfRegisterCOMShared
14:24:51 End Action SelfRegister
14:24:51 Begin Action SetupRegistry:
14:24:51 SNMP service has been detected.
14:24:51 Begin Action RegWriteInstalledInstances:
14:24:51 End Action RegWriteInstalledInstances
14:24:51 Register this installation of SQL Server with MDAC
14:24:51 Completed registering this installation of SQL Server with
MDAC
14:25:07 An error occurred while creating one or more registry entries.
Please see C:\WINDOWS\\\sqlstp.log for details. The problem could be
caused by a low registry quota condition.
14:25:07 Action CleanUpInstall:
14:25:07 C:\WINDOWS\TEMP\SqlSetup\Bin\scm.exe -Silent 1 -Action 4
-Service SQLSERVERAGENT
14:25:07 Process Exit Code: (1060) Der angegebene Dienst ist kein
installierter Dienst.

14:25:07 C:\WINDOWS\TEMP\SqlSetup\Bin\scm.exe -Silent 1 -Action 4
-Service MSSQLSERVER
14:25:07 Process Exit Code: (0)
14:25:07 StatsGenerate returned: 2
14:25:07 StatsGenerate
(0x80000000,0x1,0xf000000,0x200,1033,303,0x0,0x1,0,0,0
14:25:07 StatsGenerate -1,admin)
14:25:07 Installation Failed.

I got the indentical error when I attempted to install SQL 2000 Developer's Edition on XP Pro. My log file failure occurred at the same place yours did.

I had recently installed .Net framework, .Net SDK, and ASP Web Matrix. I made a lucky guess that they were causing the problem.

I did an uninstall of:
.Net framework
.Net SDK
ASP Web Matrix

I deleted the sub folders in c:\Program Files\Microsoft SQL Server.

Then SQL 2000 DE installed successfully, and I reinstalled the .Net framework & ASP Web Matrix.

Hope this helps.