I've already read many topics that was asked about SSIS runtime, but for my purposes I didn't find satisfied answer
Our clients don't use SQL Server for their data. But we anyway used DTS packages for transfering data between client DBes. Only thing that we needed to install was DTS dlls.
What will I need to do now to use old DTS and new SSIS packages on these clients?
I am created a SSIS package to export data. I am exporting query data to a flat file to a different server. I tried to use the UNC path and it failed saying could not access the file. How can I create a SSIS package to export data from one server to another?
View 5 Replies View RelatedNew thread.
I tried following/have info on prior long thread on issue ...
> Extracted SP-1
> Ran JS script (info below)
> Re-ran SP-2, failed. (info below)
> (DTS9_Hotfix_KB921896_sqlrun_dts.msp.log info below)
JS script OUTPUT BELOW
=====================================================================
D:Hotfix_2175x86>cscript RepairMSPSource.js "D:Hotfix_2175x86"
Microsoft (R) Windows Script Host Version 5.6
Copyright (C) Microsoft Corporation 1996-2001. All rights reserved.
Found patch located at: D:Hotfix_2175x86hotfixasfilessqlrun_as.msp
Attempting to repair the local cache for PatchCode "{731AC539-10A2-4073-ADD2-49F74ED65EE6}"
No action can be taken as the patch has not been applied on the local machine.
Found patch located at: D:Hotfix_2175x86hotfixdtsfilessqlrun_dts.msp
Attempting to repair the local cache for PatchCode "{8B7E2749-624E-4C61-92FC-2BC18307FF24}"
D:Hotfix_2175x86RepairMSPSource.js(159, 17) Msi API Error: PatchProperty,Property
Summary.txt OUTPUT BELOW
=====================================================================
Time: 03/29/2007 10:54:04.278
KB Number: KB921896
Machine: BPATLQQDW
OS Version: Microsoft Windows Server 2003 family, Standard Edition Service Pack 1 (Build 3790)
Package Language: 1033 (ENU)
Package Platform: x86
Package SP Level: 2
Package Version: 3042
Command-line parameters specified:
Cluster Installation: No
**********************************************************************************
Prerequisites Check & Status
SQLSupport: Passed
**********************************************************************************
Products Detected Language Level Patch Level Platform Edition
Setup Support Files ENU 9.2.3042 x86
Database Services (ATLQQDW01) ENU SP2 2005.090.3042.00 x86 STANDARD
Analysis Services (ATLQQDW01) ENU SP2 2005.090.3042.00 x86 STANDARD
Reporting Services (ATLQQDW01) ENU SP2 9.00.3042.00 x86 STANDARD
Notification Services ENU SP1 9.00.2047.00 x86 ENTERPRISE
Integration Services ENU SP1 9.00.2047.00 x86 ENTERPRISE
SQL Server Native Client ENU 9.00.3042.00 x86
Client Components ENU SP2 9.2.3042 x86 STANDARD
MSXML 6.0 Parser ENU 6.10.1129.0 x86
SQLXML4 ENU 9.00.3042.00 x86
Backward Compatibility ENU 8.05.2004 x86
Microsoft SQL Server VSS Writer ENU 9.00.3042.00 x86
**********************************************************************************
Products Disqualified & Reason
Product Reason
**********************************************************************************
Processes Locking Files
Process Name Feature Type User Name PID
**********************************************************************************
Product Installation Status
Product : Setup Support Files
Product Version (Previous): 3042
Product Version (Final) :
Status : Not Selected
Log File :
Error Description :
----------------------------------------------------------------------------------
Product : Database Services (ATLQQDW01)
Product Version (Previous): 3042
Product Version (Final) :
Status : Not Selected
Log File :
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : Analysis Services (ATLQQDW01)
Product Version (Previous): 3042
Product Version (Final) :
Status : Not Selected
Log File :
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : Reporting Services (ATLQQDW01)
Product Version (Previous): 3042
Product Version (Final) :
Status : Not Selected
Log File :
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : Notification Services
Product Version (Previous): 2047
Product Version (Final) :
Status : Failure
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixNS9_Hotfix_KB921896_sqlrun_ns.msp.log
Error Number : 1612
Error Description : Unable to install Windows Installer MSP file
----------------------------------------------------------------------------------
Product : Integration Services
Product Version (Previous): 2047
Product Version (Final) :
Status : Failure
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixDTS9_Hotfix_KB921896_sqlrun_dts.msp.log
Error Number : 1612
Error Description : Unable to install Windows Installer MSP file
----------------------------------------------------------------------------------
Product : SQL Server Native Client
Product Version (Previous): 3042
Product Version (Final) :
Status : Not Selected
Log File :
Error Description :
----------------------------------------------------------------------------------
Product : Client Components
Product Version (Previous): 3042
Product Version (Final) :
Status : Not Selected
Log File :
Error Description :
----------------------------------------------------------------------------------
Product : MSXML 6.0 Parser
Product Version (Previous): 1129
Product Version (Final) :
Status : Not Selected
Log File :
Error Description :
----------------------------------------------------------------------------------
Product : SQLXML4
Product Version (Previous): 3042
Product Version (Final) :
Status : Not Selected
Log File :
Error Description :
----------------------------------------------------------------------------------
Product : Backward Compatibility
Product Version (Previous): 2004
Product Version (Final) :
Status : Not Selected
Log File :
Error Description :
----------------------------------------------------------------------------------
Product : Microsoft SQL Server VSS Writer
Product Version (Previous): 3042
Product Version (Final) :
Status : Not Selected
Log File :
Error Description :
----------------------------------------------------------------------------------
**********************************************************************************
Summary
One or more products failed to install, see above for details
Exit Code Returned: 1612
HotFix.log OUTPUT BELOW
=====================================================================
03/29/2007 10:15:12.964 ================================================================================
03/29/2007 10:15:12.964 Hotfix package launched
03/29/2007 10:15:12.996 Registry: Opened registry key "SOFTWAREMicrosoftWindowsCurrentVersion"
03/29/2007 10:15:12.996 Registry: Read registry key value "CommonFilesDir", string value = C:Program FilesCommon Files
03/29/2007 10:15:12.996 Registry: Opened registry key "SOFTWAREMicrosoftWindowsCurrentVersion"
03/29/2007 10:15:12.996 Registry: Read registry key value "ProgramFilesDir", string value = C:Program Files
03/29/2007 10:15:12.996 Local Computer:
03/29/2007 10:15:12.996 Target Details: BPATLQQDW
03/29/2007 10:15:12.996 commonfilesdir = C:Program FilesCommon Files
03/29/2007 10:15:12.996 lcidsupportdir = D:Installs1033
03/29/2007 10:15:12.996 programfilesdir = C:Program Files
03/29/2007 10:15:12.996 programfilesdir_wow = C:Program Files
03/29/2007 10:15:12.996 supportdir = D:Installs
03/29/2007 10:15:12.996 supportdirlocal = D:Installs
03/29/2007 10:15:12.996 windir = C:WINDOWS
03/29/2007 10:15:13.011 winsysdir = C:WINDOWSsystem32
03/29/2007 10:15:13.011 winsysdir_wow = C:WINDOWSSysWOW64
03/29/2007 10:15:13.011
03/29/2007 10:15:13.011 Enumerating applicable products for this patch
03/29/2007 10:15:13.027 Found Redist 2005 product definition
03/29/2007 10:15:13.043 Registry: Opened registry key "SOFTWAREMicrosoftWindowsCurrentVersion"
03/29/2007 10:15:13.043 Registry: Read registry key value "CommonFilesDir", string value = C:Program FilesCommon Files
03/29/2007 10:15:13.043 Registry: Opened registry key "SOFTWAREMicrosoftWindowsCurrentVersion"
03/29/2007 10:15:13.043 Registry: Read registry key value "ProgramFilesDir", string value = C:Program Files
03/29/2007 10:15:13.683 Found Redist 2005 product definition
03/29/2007 10:15:13.699 Found Redist 2005 product definition
03/29/2007 10:15:13.730 Registry: Opened registry key "SOFTWAREMicrosoftWindowsCurrentVersion"
03/29/2007 10:15:13.730 Registry: Read registry key value "CommonFilesDir", string value = C:Program FilesCommon Files
03/29/2007 10:15:13.730 Registry: Opened registry key "SOFTWAREMicrosoftWindowsCurrentVersion"
03/29/2007 10:15:13.730 Registry: Read registry key value "ProgramFilesDir", string value = C:Program Files
03/29/2007 10:15:13.996 Found SQL 2005 product definition
03/29/2007 10:15:20.886 Enumeration: Determining QFE level for product instance ATLQQDW01
03/29/2007 10:15:20.886 Enumeration: Associated hotfix build information not found for the following file: D:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnSQLServr.exe
03/29/2007 10:15:20.886 Enumeration: Found following QFE level for product instance ATLQQDW01: 3042
03/29/2007 10:15:20.902 Enumeration: Determining GDR branching Hotfix for product instance ATLQQDW01
03/29/2007 10:15:20.902 Enumeration: Associated hotfix build information not found for the following file: D:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnSQLServr.exe
03/29/2007 10:15:20.902 Enumeration: No GDR branch Hotfix found for product instance ATLQQDW01
03/29/2007 10:15:20.917 Registry: Opened registry key "SOFTWAREMicrosoftWindowsCurrentVersion"
03/29/2007 10:15:20.917 Registry: Read registry key value "CommonFilesDir", string value = C:Program FilesCommon Files
03/29/2007 10:15:20.917 Registry: Opened registry key "SOFTWAREMicrosoftWindowsCurrentVersion"
03/29/2007 10:15:20.917 Registry: Read registry key value "ProgramFilesDir", string value = C:Program Files
03/29/2007 10:15:20.917 Product discovery completed during the install process for ATLQQDW01
03/29/2007 10:15:20.917 SP Level check completed during the install process for ATLQQDW01
03/29/2007 10:15:20.917 Product language check completed during the install process for ATLQQDW01
03/29/2007 10:15:20.917 Product version check completed during the install process for ATLQQDW01
03/29/2007 10:15:20.917 Command-line instance name check completed during the install process
03/29/2007 10:15:20.917 SKU check completed during the install process for ATLQQDW01
03/29/2007 10:15:20.917 Baseline build check completed during the install process
03/29/2007 10:15:20.933 Found OLAP Server 2005 product definition
03/29/2007 10:15:43.214 Enumeration: Determining QFE level for product instance ATLQQDW01
03/29/2007 10:15:43.230 Enumeration: Associated hotfix build information not found for the following file: D:Program FilesMicrosoft SQL ServerMSSQL.2OLAP\Binmsmdsrv.exe
03/29/2007 10:15:43.230 Enumeration: Found following QFE level for product instance ATLQQDW01: 3042
03/29/2007 10:15:43.230 Enumeration: Determining GDR branching Hotfix for product instance ATLQQDW01
03/29/2007 10:15:43.230 Enumeration: Associated hotfix build information not found for the following file: D:Program FilesMicrosoft SQL ServerMSSQL.2OLAP\Binmsmdsrv.exe
03/29/2007 10:15:43.230 Enumeration: No GDR branch Hotfix found for product instance ATLQQDW01
03/29/2007 10:15:43.230 Registry: Opened registry key "SOFTWAREMicrosoftWindowsCurrentVersion"
03/29/2007 10:15:43.245 Registry: Read registry key value "CommonFilesDir", string value = C:Program FilesCommon Files
03/29/2007 10:15:43.245 Registry: Opened registry key "SOFTWAREMicrosoftWindowsCurrentVersion"
03/29/2007 10:15:43.245 Registry: Read registry key value "ProgramFilesDir", string value = C:Program Files
03/29/2007 10:15:43.245 Product discovery completed during the install process for ATLQQDW01
03/29/2007 10:15:43.245 SP Level check completed during the install process for ATLQQDW01
03/29/2007 10:15:43.245 Product language check completed during the install process for ATLQQDW01
03/29/2007 10:15:43.245 Product version check completed during the install process for ATLQQDW01
03/29/2007 10:15:43.245 Command-line instance name check completed during the install process
03/29/2007 10:15:43.245 Baseline build check completed during the install process
03/29/2007 10:15:43.261 Found Notification Services 2005 product definition
03/29/2007 10:16:05.558 Enumeration: Determining QFE level for product instance
03/29/2007 10:16:05.589 Enumeration: Associated hotfix build information not found for the following file: C:Program FilesMicrosoft SQL Server90NotificationServices9.0.242\Binsservice.exe
03/29/2007 10:16:05.636 Enumeration: Found following QFE level for product instance : 2047
03/29/2007 10:16:05.636 Enumeration: Determining GDR branching Hotfix for product instance
03/29/2007 10:16:05.651 Enumeration: Associated hotfix build information not found for the following file: C:Program FilesMicrosoft SQL Server90NotificationServices9.0.242\Binsservice.exe
03/29/2007 10:16:05.651 Enumeration: No GDR branch Hotfix found for product instance
03/29/2007 10:16:05.776 Registry: Opened registry key "SOFTWAREMicrosoftWindowsCurrentVersion"
03/29/2007 10:16:05.792 Registry: Read registry key value "CommonFilesDir", string value = C:Program FilesCommon Files
03/29/2007 10:16:05.792 Registry: Opened registry key "SOFTWAREMicrosoftWindowsCurrentVersion"
03/29/2007 10:16:05.792 Registry: Read registry key value "ProgramFilesDir", string value = C:Program Files
03/29/2007 10:16:05.808 Product discovery completed during the install process for NS
03/29/2007 10:16:05.808 SP Level check completed during the install process for NS
03/29/2007 10:16:05.808 Product language check completed during the install process for NS
03/29/2007 10:16:05.808 Product version check completed during the install process for NS
03/29/2007 10:16:05.808 Baseline build check completed during the installation process for NS
03/29/2007 10:16:05.808 Baseline build check completed during the install process
03/29/2007 10:16:05.823 Found Report Server 2005 product definition
03/29/2007 10:16:12.354 Enumeration: Determining QFE level for product instance ATLQQDW01
03/29/2007 10:16:12.354 Enumeration: Associated hotfix build information not found for the following file: D:Program FilesMicrosoft SQL ServerMSSQL.3Reporting Services\ReportServerinReportingServicesService.exe
03/29/2007 10:16:12.370 Enumeration: Found following QFE level for product instance ATLQQDW01: 3042
03/29/2007 10:16:12.370 Enumeration: Determining GDR branching Hotfix for product instance ATLQQDW01
03/29/2007 10:16:12.370 Enumeration: Associated hotfix build information not found for the following file: D:Program FilesMicrosoft SQL ServerMSSQL.3Reporting Services\ReportServerinReportingServicesService.exe
03/29/2007 10:16:12.370 Enumeration: No GDR branch Hotfix found for product instance ATLQQDW01
03/29/2007 10:16:12.370 Registry: Opened registry key "SOFTWAREMicrosoftWindowsCurrentVersion"
03/29/2007 10:16:12.370 Registry: Read registry key value "CommonFilesDir", string value = C:Program FilesCommon Files
03/29/2007 10:16:12.370 Registry: Opened registry key "SOFTWAREMicrosoftWindowsCurrentVersion"
03/29/2007 10:16:12.386 Registry: Read registry key value "ProgramFilesDir", string value = C:Program Files
03/29/2007 10:16:12.386 Product discovery completed during the install process for ATLQQDW01
03/29/2007 10:16:12.386 SP Level check completed during the install process for ATLQQDW01
03/29/2007 10:16:12.386 Product language check completed during the install process for ATLQQDW01
03/29/2007 10:16:12.386 Product version check completed during the install process for ATLQQDW01
03/29/2007 10:16:12.386 Command-line instance name check completed during the install process
03/29/2007 10:16:12.386 SKU check completed during the install process for ATLQQDW01
03/29/2007 10:16:12.386 Baseline build check completed during the install process
03/29/2007 10:16:12.386 Found DTS 2005 product definition
03/29/2007 10:16:34.463 Enumeration: Determining QFE level for product instance
03/29/2007 10:16:34.463 Enumeration: Associated hotfix build information not found for the following file: C:Program FilesMicrosoft SQL Server90DTS\Binnmsdtssrvr.exe
03/29/2007 10:16:34.495 Enumeration: Found following QFE level for product instance : 2047
03/29/2007 10:16:34.495 Enumeration: Determining GDR branching Hotfix for product instance
03/29/2007 10:16:34.495 Enumeration: Associated hotfix build information not found for the following file: C:Program FilesMicrosoft SQL Server90DTS\Binnmsdtssrvr.exe
03/29/2007 10:16:34.495 Enumeration: No GDR branch Hotfix found for product instance
03/29/2007 10:16:34.495 Registry: Opened registry key "SOFTWAREMicrosoftWindowsCurrentVersion"
03/29/2007 10:16:34.495 Registry: Read registry key value "CommonFilesDir", string value = C:Program FilesCommon Files
03/29/2007 10:16:34.510 Registry: Opened registry key "SOFTWAREMicrosoftWindowsCurrentVersion"
03/29/2007 10:16:34.510 Registry: Read registry key value "ProgramFilesDir", string value = C:Program Files
03/29/2007 10:16:34.510 Product discovery completed during the install process for Integration Services
03/29/2007 10:16:34.510 SP Level check completed during the install process for Integration Services
03/29/2007 10:16:34.510 Product language check completed during the install process for Integration Services
03/29/2007 10:16:34.510 Product version check completed during the install process for Integration Services
03/29/2007 10:16:34.510 Baseline build check completed during the installation process for Integration Services
03/29/2007 10:16:34.510 Baseline build check completed during the install process
03/29/2007 10:16:34.510 Found SQL 2005 Tools product definition
03/29/2007 10:16:56.666 Enumeration: Determining GDR branching Hotfix for product instance
03/29/2007 10:16:56.682 Enumeration: Associated hotfix build information not found for the following file: C:Program FilesMicrosoft SQL Server90Tools\BinnVSShellCommon7IDESQLWB.EXE
03/29/2007 10:16:56.682 Enumeration: No GDR branch Hotfix found for product instance
03/29/2007 10:16:56.697 Registry: Opened registry key "SOFTWAREMicrosoftWindowsCurrentVersion"
03/29/2007 10:16:56.697 Registry: Read registry key value "CommonFilesDir", string value = C:Program FilesCommon Files
03/29/2007 10:16:56.697 Registry: Opened registry key "SOFTWAREMicrosoftWindowsCurrentVersion"
03/29/2007 10:16:56.697 Registry: Read registry key value "ProgramFilesDir", string value = C:Program Files
03/29/2007 10:16:56.697 Product discovery completed during the install process for SQL Tools
03/29/2007 10:16:56.697 SP Level check completed during the install process for SQL Tools
03/29/2007 10:16:56.697 Product language check completed during the install process for SQL Tools
03/29/2007 10:16:56.697 Product version check completed during the install process for SQL Tools
03/29/2007 10:16:56.697 SKU check completed during the install process for SQL Tools
03/29/2007 10:16:56.697 Baseline build check completed during the install process
03/29/2007 10:16:56.713 Found Redist 2005 product definition
03/29/2007 10:16:56.713 Registry: Opened registry key "SOFTWAREMicrosoftWindowsCurrentVersion"
03/29/2007 10:16:56.713 Registry: Read registry key value "CommonFilesDir", string value = C:Program FilesCommon Files
03/29/2007 10:16:56.729 Registry: Opened registry key "SOFTWAREMicrosoftWindowsCurrentVersion"
03/29/2007 10:16:56.729 Registry: Read registry key value "ProgramFilesDir", string value = C:Program Files
03/29/2007 10:16:57.119 Found Redist 2005 product definition
03/29/2007 10:16:57.135 Found Redist 2005 product definition
03/29/2007 10:16:57.151 Registry: Opened registry key "SOFTWAREMicrosoftWindowsCurrentVersion"
03/29/2007 10:16:57.151 Registry: Read registry key value "CommonFilesDir", string value = C:Program FilesCommon Files
03/29/2007 10:16:57.151 Registry: Opened registry key "SOFTWAREMicrosoftWindowsCurrentVersion"
03/29/2007 10:16:57.151 Registry: Read registry key value "ProgramFilesDir", string value = C:Program Files
03/29/2007 10:16:57.479 Found Redist 2005 product definition
03/29/2007 10:16:57.494 Found Redist 2005 product definition
03/29/2007 10:16:57.510 Registry: Opened registry key "SOFTWAREMicrosoftWindowsCurrentVersion"
03/29/2007 10:16:57.510 Registry: Read registry key value "CommonFilesDir", string value = C:Program FilesCommon Files
03/29/2007 10:16:57.526 Registry: Opened registry key "SOFTWAREMicrosoftWindowsCurrentVersion"
03/29/2007 10:16:57.526 Registry: Read registry key value "ProgramFilesDir", string value = C:Program Files
03/29/2007 10:16:58.244 Found Redist 2005 product definition
03/29/2007 10:16:58.260 Found Redist 2005 product definition
03/29/2007 10:16:58.276 Registry: Opened registry key "SOFTWAREMicrosoftWindowsCurrentVersion"
03/29/2007 10:16:58.276 Registry: Read registry key value "CommonFilesDir", string value = C:Program FilesCommon Files
03/29/2007 10:16:58.291 Registry: Opened registry key "SOFTWAREMicrosoftWindowsCurrentVersion"
03/29/2007 10:16:58.291 Registry: Read registry key value "ProgramFilesDir", string value = C:Program Files
03/29/2007 10:16:58.619 Found Redist 2005 product definition
03/29/2007 10:16:58.729 Product Enumeration Results:
03/29/2007 10:16:58.729 INF File Name: D:InstallsHotFixSqlncli.inf
03/29/2007 10:16:58.729 baselinebuild = 1399
03/29/2007 10:16:58.729 build = 3042
03/29/2007 10:16:58.729 description = SQL Server Native Client
03/29/2007 10:16:58.744 details = Service Pack for Microsoft SQL Server Native Client.
03/29/2007 10:16:58.744 installerlogpath = <PROGRAMFILESDIR>Microsoft SQL Server90Setup BootstrapLOGHotfix
03/29/2007 10:16:58.744 kbarticle = KB921896
03/29/2007 10:16:58.744 kbarticlehyperlink = http://support.microsoft.com/?kbid=921896
03/29/2007 10:16:58.744 lcid = 1033
03/29/2007 10:16:58.744 legalproductname = Microsoft SQL Native Client
03/29/2007 10:16:58.744 machinetype = x86
03/29/2007 10:16:58.744 package = HotFixSqlncli
03/29/2007 10:16:58.744 packagetype = Hotfix
03/29/2007 10:16:58.744 productcode = {F9B3DD02-B0B3-42E9-8650-030DFF0D133D}
03/29/2007 10:16:58.744 productname = Redist9
03/29/2007 10:16:58.744 recommendinstall = 1
03/29/2007 10:16:58.744 relatedlinks = <LCIDSUPPORTDIR>FinalSQL2005Information.rtf
03/29/2007 10:16:58.744 servicepackname = Microsoft SQL Server 2005 Service Pack 2 Setup
03/29/2007 10:16:58.744 splevel = 2
03/29/2007 10:16:58.744 sqladminprovisioningtool = <PROGRAMFILESDIR_WOW>Microsoft SQL Server90Sharedsqlprov.exe
03/29/2007 10:16:58.744 supportdir = D:Installs
03/29/2007 10:16:58.744 upgradecode = {A6B19337-7392-4765-8675-5C25B758BA37}
03/29/2007 10:16:58.744 version = 9
03/29/2007 10:16:58.744
03/29/2007 10:16:58.744 File Group Details: MSI
03/29/2007 10:16:58.744 cachedmsipath = <PROGRAMFILESDIR>Microsoft SQL Server90Setup BootstrapCache
03/29/2007 10:16:58.744 sourcepath = <SUPPORTDIR><PACKAGE>Files
03/29/2007 10:16:58.760 File Details: sqlncli.msi
03/29/2007 10:16:58.760
03/29/2007 10:16:58.760 Instance Details: SQL Server Native Client
03/29/2007 10:16:58.760 fullversion = 9.00.3042.00
03/29/2007 10:16:58.760 lcid = 1033
03/29/2007 10:16:58.760 productcode = {F9B3DD02-B0B3-42E9-8650-030DFF0D133D}
03/29/2007 10:16:58.760 qfelevel = 3042
03/29/2007 10:16:58.760 sp = -1
03/29/2007 10:16:58.760
03/29/2007 10:16:58.760 Product Enumeration Results:
03/29/2007 10:16:58.760 INF File Name: D:InstallsHotFixSqlncli_x64.inf
03/29/2007 10:16:58.760 baselinebuild = 1399
03/29/2007 10:16:58.760 build = 3042
03/29/2007 10:16:58.760 description = SQL Server Native Client
03/29/2007 10:16:58.760 details = Service Pack for Microsoft SQL Server Native Client.
03/29/2007 10:16:58.760 installerlogpath = <PROGRAMFILESDIR>Microsoft SQL Server90Setup BootstrapLOGHotfix
03/29/2007 10:16:58.760 kbarticle = KB921896
03/29/2007 10:16:58.760 kbarticlehyperlink = http://support.microsoft.com/?kbid=921896
03/29/2007 10:16:58.760 lcid = 1033
03/29/2007 10:16:58.760 legalproductname = Microsoft SQL Native Client (64-bit)
03/29/2007 10:16:58.760 machinetype = x64
03/29/2007 10:16:58.760 package = HotFixSqlncli_x64
03/29/2007 10:16:58.760 packagetype = Hotfix
03/29/2007 10:16:58.776 productname = Redist9
03/29/2007 10:16:58.776 recommendinstall = 1
03/29/2007 10:16:58.776 relatedlinks = <LCIDSUPPORTDIR>FinalSQL2005Information.rtf
03/29/2007 10:16:58.776 servicepackname = Microsoft SQL Server 2005 Service Pack 2 Setup
03/29/2007 10:16:58.776 splevel = 2
03/29/2007 10:16:58.776 supportdir = D:Installs
03/29/2007 10:16:58.776 upgradecode = {6EC3319D-84BE-4C32-AA91-7D6057CF05A5}
03/29/2007 10:16:58.776 version = 9
03/29/2007 10:16:58.776
03/29/2007 10:16:58.776 File Group Details: MSI
03/29/2007 10:16:58.776 cachedmsipath = <PROGRAMFILESDIR>Microsoft SQL Server90Setup BootstrapCache
03/29/2007 10:16:58.776 sourcepath = <SUPPORTDIR><PACKAGE>Files
03/29/2007 10:16:58.776 File Details: sqlncli_x64.msi
03/29/2007 10:16:58.776
03/29/2007 10:16:58.776 Product Enumeration Results:
03/29/2007 10:16:58.776 INF File Name: D:InstallsHotFixSqlSupport.inf
03/29/2007 10:16:58.776 alwaysinstall = 1
03/29/2007 10:16:58.776 baselinebuild = 1399
03/29/2007 10:16:58.776 build = 3042
03/29/2007 10:16:58.776 description = Setup Support Files
03/29/2007 10:16:58.776 details = Service Pack for the SQL Server support files.
03/29/2007 10:16:58.776 installerlogpath = <PROGRAMFILESDIR>Microsoft SQL Server90Setup BootstrapLOGHotfix
03/29/2007 10:16:58.791 kbarticle = KB921896
03/29/2007 10:16:58.791 kbarticlehyperlink = http://support.microsoft.com/?kbid=921896
03/29/2007 10:16:58.791 keyqualifier = 1
03/29/2007 10:16:58.791 lcid = 1033
03/29/2007 10:16:58.791 legalproductname = SQL Server 2005 Setup Support Files
03/29/2007 10:16:58.791 machinetype = x86
03/29/2007 10:16:58.791 package = HotFixSqlSupport
03/29/2007 10:16:58.791 packagetype = Hotfix
03/29/2007 10:16:58.791 productcode = {53F5C3EE-05ED-4830-994B-50B2F0D50FCE}
03/29/2007 10:16:58.791 productname = Redist9
03/29/2007 10:16:58.791 relatedlinks = <LCIDSUPPORTDIR>FinalSQL2005Information.rtf
03/29/2007 10:16:58.791 servicepackname = Microsoft SQL Server 2005 Service Pack 2 Setup
03/29/2007 10:16:58.791 splevel = 2
03/29/2007 10:16:58.791 sqladminprovisioningtool = <PROGRAMFILESDIR_WOW>Microsoft SQL Server90Sharedsqlprov.exe
03/29/2007 10:16:58.791 supportdir = D:Installs
03/29/2007 10:16:58.791 upgradecode = {3A91FA19-A197-467C-850F-0AFE90899371}
03/29/2007 10:16:58.791 version = 9
03/29/2007 10:16:58.791
03/29/2007 10:16:58.791 File Group Details: MSI
03/29/2007 10:16:58.791 cachedmsipath = <PROGRAMFILESDIR>Microsoft SQL Server90Setup BootstrapCacheSQLSupport<MachineType><LCID>
03/29/2007 10:16:58.791 parameters = REINSTALL=ALL
03/29/2007 10:16:58.791 sourcepath = <SUPPORTDIR><PACKAGE>Files
03/29/2007 10:16:58.807 File Details: SqlSupport.msi
03/29/2007 10:16:58.807
03/29/2007 10:16:58.807 Instance Details: Setup Support Files
03/29/2007 10:16:58.807 fullversion = 9.2.3042
03/29/2007 10:16:58.807 lcid = 1033
03/29/2007 10:16:58.807 productcode = {53F5C3EE-05ED-4830-994B-50B2F0D50FCE}
03/29/2007 10:16:58.807 qfelevel = 3042
03/29/2007 10:16:58.807 sp = -1
03/29/2007 10:16:58.807
03/29/2007 10:16:58.807 Product Enumeration Results:
03/29/2007 10:16:58.807 INF File Name: D:InstallsHotFixSQL.inf
03/29/2007 10:16:58.807 baselinebuild = 1399
03/29/2007 10:16:58.807 baselinebuildmax = 3042
03/29/2007 10:16:58.807 build = 3042
03/29/2007 10:16:58.807 description = Database Services
03/29/2007 10:16:58.807 details = Service Pack for the SQL Server database engine, and the tools for managing relational and XML data, Replication, and Full-Text Search.
03/29/2007 10:16:58.807 installer = Hotfix
03/29/2007 10:16:58.807 installerlogpath = <PROGRAMFILESDIR>Microsoft SQL Server90Setup BootstrapLOGHotfix
03/29/2007 10:16:58.807 kbarticle = KB921896
03/29/2007 10:16:58.807 kbarticlehyperlink = http://support.microsoft.com/?kbid=921896
03/29/2007 10:16:58.807 lcid = 1033
03/29/2007 10:16:58.807 legalproductname = SQL Server Database Services 2005
03/29/2007 10:16:58.807 machinetype = x86
03/29/2007 10:16:58.822 package = HotFixSQL
03/29/2007 10:16:58.822 packagetype = Hotfix
03/29/2007 10:16:58.822 productname = SQL9
03/29/2007 10:16:58.822 relatedlinks = <LCIDSUPPORTDIR>FinalSQL2005Information.rtf
03/29/2007 10:16:58.822 servicepackname = Microsoft SQL Server 2005 Service Pack 2 Setup
03/29/2007 10:16:58.822 sku = DESKTOP,STANDARD,WORKGROUP,ENTERPRISE,SBS,OFFICE,MSDE,DEVELOPERDESKTOP,DEVELOPERSTANDARD,PERSONAL,DEVELOPER,EVAL
03/29/2007 10:16:58.822 splevel = 2
03/29/2007 10:16:58.822 sqladminprovisioningtool = <PROGRAMFILESDIR_WOW>Microsoft SQL Server90Sharedsqlprov.exe
03/29/2007 10:16:58.822 sqlutility = sqlcmd.exe
03/29/2007 10:16:58.822 supportdir = D:Installs
03/29/2007 10:16:58.822 validateauthentication = true
03/29/2007 10:16:58.822 version = 9
03/29/2007 10:16:58.822
03/29/2007 10:16:58.822 File Group Details: MSP
03/29/2007 10:16:58.822 parameters = SQLBUILD=3042 KBNUMBER=KB921896 REBOOT=ReallySuppress
03/29/2007 10:16:58.822 sourcepath = <SUPPORTDIR><PACKAGE>Files
03/29/2007 10:16:58.822 File Details: sqlrun_sql.msp
03/29/2007 10:16:58.822
03/29/2007 10:16:58.822 Instance Details: ATLQQDW01
03/29/2007 10:16:58.822 agentservicename = SQLAgent$ATLQQDW01
03/29/2007 10:16:58.822 associatedhotfixbuild = 1520
03/29/2007 10:16:58.822 clustername =
03/29/2007 10:16:58.822 ftsservicename = MSFTESQL$ATLQQDW01
03/29/2007 10:16:58.838 fullversion = 2005.090.3042.00
03/29/2007 10:16:58.838 hiveregpath = SoftwareMicrosoftMicrosoft SQL ServerMSSQL.1
03/29/2007 10:16:58.838 id = MSSQL.1
03/29/2007 10:16:58.838 installsqldatadir = D:Program FilesMicrosoft SQL ServerMSSQL.1MSSQL
03/29/2007 10:16:58.838 installsqldir = D:Program FilesMicrosoft SQL ServerMSSQL.1MSSQL
03/29/2007 10:16:58.838 lcid = 1033
03/29/2007 10:16:58.838 name = ATLQQDW01
03/29/2007 10:16:58.838 productcode = {130A3BE1-85CC-4135-8EA7-5A724EE6CE2C}
03/29/2007 10:16:58.838 qfelevel = 3042
03/29/2007 10:16:58.838 servicename = MSSQL$ATLQQDW01
03/29/2007 10:16:58.838 sku = STANDARD
03/29/2007 10:16:58.838 sp = 2
03/29/2007 10:16:58.838 type = SQL Server Standalone Product
03/29/2007 10:16:58.838 vermajbld = 3042
03/29/2007 10:16:58.838 version = 9
03/29/2007 10:16:58.838
03/29/2007 10:16:58.838 Product Enumeration Results:
03/29/2007 10:16:58.838 INF File Name: D:InstallsHotFixAS.inf
03/29/2007 10:16:58.838 baselinebuild = 1399
03/29/2007 10:16:58.838 baselinebuildmax = 3042
03/29/2007 10:16:58.838 build = 3042
03/29/2007 10:16:58.838 description = Analysis Services
03/29/2007 10:16:58.838 details = Service Pack for Analysis Services, and the tools used to support online analytical processing (OLAP) and data mining.
03/29/2007 10:16:58.854 installer = Hotfix
03/29/2007 10:16:58.854 installerlogpath = <PROGRAMFILESDIR>Microsoft SQL Server90Setup BootstrapLOGHotfix
03/29/2007 10:16:58.854 kbarticle = KB921896
03/29/2007 10:16:58.854 kbarticlehyperlink = http://support.microsoft.com/?kbid=921896
03/29/2007 10:16:58.854 lcid = 1033
03/29/2007 10:16:58.854 legalproductname = SQL Server Analysis Services 2005
03/29/2007 10:16:58.854 machinetype = x86
03/29/2007 10:16:58.854 package = HotFixAS
03/29/2007 10:16:58.854 packagetype = Hotfix
03/29/2007 10:16:58.854 productname = OLAP9
03/29/2007 10:16:58.854 relatedlinks = <LCIDSUPPORTDIR>FinalSQL2005Information.rtf
03/29/2007 10:16:58.854 servicepackname = Microsoft SQL Server 2005 Service Pack 2 Setup
03/29/2007 10:16:58.854 splevel = 2
03/29/2007 10:16:58.854 sqladminprovisioningtool = <PROGRAMFILESDIR_WOW>Microsoft SQL Server90Sharedsqlprov.exe
03/29/2007 10:16:58.854 supportdir = D:Installs
03/29/2007 10:16:58.854 version = 9
03/29/2007 10:16:58.854
03/29/2007 10:16:58.854 File Group Details: MSP
03/29/2007 10:16:58.854 parameters = SQLBUILD=3042 KBNUMBER=KB921896 REBOOT=ReallySuppress
03/29/2007 10:16:58.854 sourcepath = <SUPPORTDIR><PACKAGE>Files
03/29/2007 10:16:58.854 File Details: sqlrun_as.msp
03/29/2007 10:16:58.854
03/29/2007 10:16:58.854 Instance Details: ATLQQDW01
03/29/2007 10:16:58.869 associatedhotfixbuild = 1520
03/29/2007 10:16:58.869 clustername =
03/29/2007 10:16:58.869 fullversion = 2005.090.3042.00
03/29/2007 10:16:58.869 hiveregpath = SoftwareMicrosoftMicrosoft SQL ServerMSSQL.2
03/29/2007 10:16:58.869 id = MSSQL.2
03/29/2007 10:16:58.869 installsqldatadir = D:Program FilesMicrosoft SQL Server
03/29/2007 10:16:58.869 installsqldir = D:Program FilesMicrosoft SQL ServerMSSQL.2OLAP
03/29/2007 10:16:58.869 lcid = 1033
03/29/2007 10:16:58.869 name = ATLQQDW01
03/29/2007 10:16:58.869 olapservicename = MSOLAP$ATLQQDW01
03/29/2007 10:16:58.869 productcode = {8ABF8FEB-ABB0-40DC-9945-85AF36EF30A9}
03/29/2007 10:16:58.869 qfelevel = 3042
03/29/2007 10:16:58.869 servicename = MSOLAP$ATLQQDW01
03/29/2007 10:16:58.869 sku = STANDARD
03/29/2007 10:16:58.869 sp = 2
03/29/2007 10:16:58.869 type = Olap Standalone Product
03/29/2007 10:16:58.869 vermajbld = 3042
03/29/2007 10:16:58.869 version = 9
03/29/2007 10:16:58.869
03/29/2007 10:16:58.869 Product Enumeration Results:
03/29/2007 10:16:58.869 INF File Name: D:InstallsHotFixNS.inf
03/29/2007 10:16:58.869 baselinebuild = 1399
03/29/2007 10:16:58.869 baselinebuildmax = 3042
03/29/2007 10:16:58.885 build = 3042
03/29/2007 10:16:58.885 description = Notification Services
03/29/2007 10:16:58.885 details = Service Pack for Notification Services, a platform for developing and deploying applications that send personalized, timely notifications to a variety of devices or applications.
03/29/2007 10:16:58.885 installer = Hotfix
03/29/2007 10:16:58.885 installerlogpath = <PROGRAMFILESDIR>Microsoft SQL Server90Setup BootstrapLOGHotfix
03/29/2007 10:16:58.885 kbarticle = KB921896
03/29/2007 10:16:58.885 kbarticlehyperlink = http://support.microsoft.com/?kbid=921896
03/29/2007 10:16:58.885 lcid = 1033
03/29/2007 10:16:58.885 legalproductname = SQL Server Notification Services 2005 instances
03/29/2007 10:16:58.885 machinetype = x86
03/29/2007 10:16:58.885 package = HotFixNS
03/29/2007 10:16:58.885 packagetype = Hotfix
03/29/2007 10:16:58.885 productname = NS9
03/29/2007 10:16:58.885 recommendinstall = 1
03/29/2007 10:16:58.885 relatedlinks = <LCIDSUPPORTDIR>FinalSQL2005Information.rtf
03/29/2007 10:16:58.885 servicepackname = Microsoft SQL Server 2005 Service Pack 2 Setup
03/29/2007 10:16:58.885 splevel = 2
03/29/2007 10:16:58.885 sqladminprovisioningtool = <PROGRAMFILESDIR_WOW>Microsoft SQL Server90Sharedsqlprov.exe
03/29/2007 10:16:58.885 supportdir = D:Installs
03/29/2007 10:16:58.885 version = 9
03/29/2007 10:16:58.885
03/29/2007 10:16:58.885 File Group Details: MSP
03/29/2007 10:16:58.885 parameters = SQLBUILD=3042 KBNUMBER=KB921896 REBOOT=ReallySuppress
03/29/2007 10:16:58.901 sourcepath = <SUPPORTDIR><PACKAGE>Files
03/29/2007 10:16:58.901 File Details: sqlrun_ns.msp
03/29/2007 10:16:58.901
03/29/2007 10:16:58.901 Instance Details: NS
03/29/2007 10:16:58.901 associatedhotfixbuild = 0
03/29/2007 10:16:58.901 clustername =
03/29/2007 10:16:58.901 fullversion = 9.00.2047.00
03/29/2007 10:16:58.901 hiveregpath = SoftwareMicrosoftMicrosoft SQL Server90NS
03/29/2007 10:16:58.901 id =
03/29/2007 10:16:58.901 installsqldatadir =
03/29/2007 10:16:58.901 installsqldir = C:Program FilesMicrosoft SQL Server90NotificationServices9.0.242
03/29/2007 10:16:58.901 lcid = 1033
03/29/2007 10:16:58.901 name =
03/29/2007 10:16:58.901 productcode = {C0B81E26-F7D0-4E84-941A-21C438BC586D}
03/29/2007 10:16:58.901 qfelevel = 2047
03/29/2007 10:16:58.901 sku = ENTERPRISE
03/29/2007 10:16:58.901 sp = 1
03/29/2007 10:16:58.901 type = Tools Only
03/29/2007 10:16:58.901 vermajbld = 2047
03/29/2007 10:16:58.901 version = 9
03/29/2007 10:16:58.901
03/29/2007 10:16:58.901 Product Enumeration Results:
03/29/2007 10:16:58.901 INF File Name: D:InstallsHotFixRS.inf
03/29/2007 10:16:58.916 baselinebuild = 1399
03/29/2007 10:16:58.916 baselinebuildmax = 3042
03/29/2007 10:16:58.916 build = 3042
03/29/2007 10:16:58.916 description = Reporting Services
03/29/2007 10:16:58.916 details = Service Pack for the Report Server and Report Builder, which manages, executes, renders, and distributes reports.
03/29/2007 10:16:58.916 installer = Hotfix
03/29/2007 10:16:58.916 installerlogpath = <PROGRAMFILESDIR>Microsoft SQL Server90Setup BootstrapLOGHotfix
03/29/2007 10:16:58.916 kbarticle = KB921896
03/29/2007 10:16:58.916 kbarticlehyperlink = http://support.microsoft.com/?kbid=921896
03/29/2007 10:16:58.916 lcid = 1033
03/29/2007 10:16:58.916 legalproductname = SQL Server Reporting Services 2005
03/29/2007 10:16:58.916 machinetype = x86
03/29/2007 10:16:58.916 package = HotFixRS
03/29/2007 10:16:58.916 packagetype = Hotfix
03/29/2007 10:16:58.916 productname = RS9
03/29/2007 10:16:58.916 relatedlinks = <LCIDSUPPORTDIR>FinalSQL2005Information.rtf
03/29/2007 10:16:58.916 servicepackname = Microsoft SQL Server 2005 Service Pack 2 Setup
03/29/2007 10:16:58.916 sku = DESKTOP,STANDARD,WORKGROUP,ENTERPRISE,SBS,OFFICE,MSDE,DEVELOPERDESKTOP,DEVELOPERSTANDARD,PERSONAL,DEVELOPER,EVAL
03/29/2007 10:16:58.916 splevel = 2
03/29/2007 10:16:58.916 sqladminprovisioningtool = <PROGRAMFILESDIR_WOW>Microsoft SQL Server90Sharedsqlprov.exe
03/29/2007 10:16:58.916 sqlutility = sqlcmd.exe
03/29/2007 10:16:58.916 supportdir = D:Installs
03/29/2007 10:16:58.916 validateauthentication = 1
03/29/2007 10:16:58.932 version = 9
03/29/2007 10:16:58.932
03/29/2007 10:16:58.932 File Group Details: MSP
03/29/2007 10:16:58.932 parameters = SQLBUILD=3042 KBNUMBER=KB921896 REBOOT=ReallySuppress
03/29/2007 10:16:58.932 sourcepath = <SUPPORTDIR><PACKAGE>Files
03/29/2007 10:16:58.932 File Details: sqlrun_rs.msp
03/29/2007 10:16:58.932
03/29/2007 10:16:58.932 Instance Details: ATLQQDW01
03/29/2007 10:16:58.932 associatedhotfixbuild = 1520
03/29/2007 10:16:58.932 clustername =
03/29/2007 10:16:58.932 fullversion = 9.00.3042.00
03/29/2007 10:16:58.932 hiveregpath = SoftwareMicrosoftMicrosoft SQL ServerMSSQL.3
03/29/2007 10:16:58.932 id = MSSQL.3
03/29/2007 10:16:58.932 installsqldatadir =
03/29/2007 10:16:58.932 installsqldir = D:Program FilesMicrosoft SQL ServerMSSQL.3Reporting Services
03/29/2007 10:16:58.932 lcid = 1033
03/29/2007 10:16:58.932 name = ATLQQDW01
03/29/2007 10:16:58.932 productcode = {E930E839-998E-42F9-97E2-71FC960DB1B7}
03/29/2007 10:16:58.932 qfelevel = 3042
03/29/2007 10:16:58.932 rsservicename = ReportServer$ATLQQDW01
03/29/2007 10:16:58.932 servicename = ReportServer$ATLQQDW01
03/29/2007 10:16:58.932 sku = STANDARD
03/29/2007 10:16:58.932 sp = 2
03/29/2007 10:16:58.947 type = Report Server Standalone Product
03/29/2007 10:16:58.947 vermajbld = 3042
03/29/2007 10:16:58.947 version = 9
03/29/2007 10:16:58.947
03/29/2007 10:16:58.947 Product Enumeration Results:
03/29/2007 10:16:58.947 INF File Name: D:InstallsHotFixDTS.inf
03/29/2007 10:16:58.947 baselinebuild = 1399
03/29/2007 10:16:58.947 baselinebuildmax = 3042
03/29/2007 10:16:58.947 build = 3042
03/29/2007 10:16:58.947 description = Integration Services
03/29/2007 10:16:58.947 details = Service Pack for Integration Services, a set of tools and programmable objects used to create and manage packages that extract, transform, and load data, as well as perform tasks.
03/29/2007 10:16:58.947 installer = Hotfix
03/29/2007 10:16:58.947 installerlogpath = <PROGRAMFILESDIR>Microsoft SQL Server90Setup BootstrapLOGHotfix
03/29/2007 10:16:58.947 kbarticle = KB921896
03/29/2007 10:16:58.947 kbarticlehyperlink = http://support.microsoft.com/?kbid=921896
03/29/2007 10:16:58.947 lcid = 1033
03/29/2007 10:16:58.947 legalproductname = SQL Server Integration Services 2005
03/29/2007 10:16:58.947 machinetype = x86
03/29/2007 10:16:58.947 package = HotFixDTS
03/29/2007 10:16:58.947 packagetype = Hotfix
03/29/2007 10:16:58.947 productname = DTS9
03/29/2007 10:16:58.947 recommendinstall = 1
03/29/2007 10:16:58.947 relatedlinks = <LCIDSUPPORTDIR>FinalSQL2005Information.rtf
03/29/2007 10:16:58.963 servicepackname = Microsoft SQL Server 2005 Service Pack 2 Setup
03/29/2007 10:16:58.963 splevel = 2
03/29/2007 10:16:58.963 sqladminprovisioningtool = <PROGRAMFILESDIR_WOW>Microsoft SQL Server90Sharedsqlprov.exe
03/29/2007 10:16:58.963 supportdir = D:Installs
03/29/2007 10:16:58.963 version = 9
03/29/2007 10:16:58.963
03/29/2007 10:16:58.963 File Group Details: MSP
03/29/2007 10:16:58.963 parameters = SQLBUILD=3042 KBNUMBER=KB921896 REBOOT=ReallySuppress
03/29/2007 10:16:58.963 sourcepath = <SUPPORTDIR><PACKAGE>Files
03/29/2007 10:16:58.963 File Details: sqlrun_dts.msp
03/29/2007 10:16:58.963
03/29/2007 10:16:58.963 Instance Details: Integration Services
03/29/2007 10:16:58.963 associatedhotfixbuild = 0
03/29/2007 10:16:58.963 clustername =
03/29/2007 10:16:58.963 dtsservicename = MsDtsServer
03/29/2007 10:16:58.963 fullversion = 9.00.2047.00
03/29/2007 10:16:58.963 hiveregpath = SoftwareMicrosoftMicrosoft SQL Server90DTS
03/29/2007 10:16:58.963 id =
03/29/2007 10:16:58.963 installsqldatadir =
03/29/2007 10:16:58.963 installsqldir = C:Program FilesMicrosoft SQL Server90DTS
03/29/2007 10:16:58.963 lcid = 1033
03/29/2007 10:16:58.963 name =
03/29/2007 10:16:58.963 productcode = {8E408A85-E0E5-4094-903F-8675707AC313}
03/29/2007 10:16:58.963 qfelevel = 2047
03/29/2007 10:16:58.979 servicename = MsDtsServer
03/29/2007 10:16:58.979 sku = ENTERPRISE
03/29/2007 10:16:58.979 sp = 1
03/29/2007 10:16:58.979 type = Tools Only
03/29/2007 10:16:58.979 vermajbld = 2047
03/29/2007 10:16:58.979 version = 9
03/29/2007 10:16:58.979
03/29/2007 10:16:58.979 Product Enumeration Results:
03/29/2007 10:16:58.979 INF File Name: D:InstallsHotFixTools.inf
03/29/2007 10:16:58.979 baselinebuild = 1399
03/29/2007 10:16:58.979 baselinebuildmax = 3042
03/29/2007 10:16:58.979 build = 3042
03/29/2007 10:16:58.979 description = Client Components
03/29/2007 10:16:58.979 details = Service Pack for the interactive management tools for running SQL Server, including SQL Server Configuration Manager, SQL Server Management Studio, SQL Profiler, and Replication Monitor.
03/29/2007 10:16:58.979 installer = Hotfix
03/29/2007 10:16:58.979 installerlogpath = <PROGRAMFILESDIR>Microsoft SQL Server90Setup BootstrapLOGHotfix
03/29/2007 10:16:58.979 kbarticle = KB921896
03/29/2007 10:16:58.979 kbarticlehyperlink = http://support.microsoft.com/?kbid=921896
03/29/2007 10:16:58.979 lcid = 1033
03/29/2007 10:16:58.979 legalproductname = SQL Server Tools and Workstation Components 2005
03/29/2007 10:16:58.979 machinetype = x86
03/29/2007 10:16:58.979 package = HotFixTools
03/29/2007 10:16:58.979 packagetype = Hotfix
03/29/2007 10:16:58.994 productname = SQLTools9
03/29/2007 10:16:58.994 recommendinstall = 1
03/29/2007 10:16:58.994 relatedlinks = <LCIDSUPPORTDIR>FinalSQL2005Information.rtf
03/29/2007 10:16:58.994 servicepackname = Microsoft SQL Server 2005 Service Pack 2 Setup
03/29/2007 10:16:58.994 sku = DESKTOP,STANDARD,WORKGROUP,ENTERPRISE,SBS,OFFICE,MSDE,DEVELOPERDESKTOP,DEVELOPERSTANDARD,PERSONAL,DEVELOPER,EVAL
03/29/2007 10:16:58.994 splevel = 2
03/29/2007 10:16:58.994 sqladminprovisioningtool = <PROGRAMFILESDIR_WOW>Microsoft SQL Server90Sharedsqlprov.exe
03/29/2007 10:16:58.994 supportdir = D:Installs
03/29/2007 10:16:58.994 version = 9
03/29/2007 10:16:58.994
03/29/2007 10:16:58.994 File Group Details: MSP
03/29/2007 10:16:58.994 parameters = SQLBUILD=3042 KBNUMBER=KB921896 REBOOT=ReallySuppress
03/29/2007 10:16:58.994 sourcepath = <SUPPORTDIR><PACKAGE>Files
03/29/2007 10:16:58.994 File Details: sqlrun_tools.msp
03/29/2007 10:16:58.994
03/29/2007 10:16:58.994 Instance Details: SQL Tools
03/29/2007 10:16:58.994 associatedhotfixbuild = 1520
03/29/2007 10:16:58.994 clustername =
03/29/2007 10:16:58.994 fullversion = 9.2.3042
03/29/2007 10:16:58.994 hiveregpath = SoftwareMicrosoftMicrosoft SQL Server90Tools
03/29/2007 10:16:58.994 id =
03/29/2007 10:16:58.994 installsqldatadir =
03/29/2007 10:16:58.994 installsqldir = C:Program FilesMicrosoft SQL Server90Tools
03/29/2007 10:16:59.010 lcid = 1033
03/29/2007 10:16:59.010 name =
03/29/2007 10:16:59.010 productcode = {1DD463C0-A50A-4394-B7E4-5895C02F9E0D}
03/29/2007 10:16:59.010 qfelevel = 3042
03/29/2007 10:16:59.010 sku = STANDARD
03/29/2007 10:16:59.010 sp = 2
03/29/2007 10:16:59.010 type = Tools Only
03/29/2007 10:16:59.010 vermajbld = 3042
03/29/2007 10:16:59.010 version = 9
03/29/2007 10:16:59.010
03/29/2007 10:16:59.010 Product Enumeration Results:
03/29/2007 10:16:59.010 INF File Name: D:InstallsHotFixMsxml6.inf
03/29/2007 10:16:59.010 baselinebuild = 1399
03/29/2007 10:16:59.010 build = 6.10.1129.0
03/29/2007 10:16:59.010 description = MSXML 6.0 Parser
03/29/2007 10:16:59.010 details = Service Pack for Microsoft XML 6.0 Parser.
03/29/2007 10:16:59.010 installerlogpath = <PROGRAMFILESDIR>Microsoft SQL Server90Setup BootstrapLOGHotfix
03/29/2007 10:16:59.010 kbarticle = KB921896
03/29/2007 10:16:59.010 kbarticlehyperlink = http://support.microsoft.com/?kbid=921896
03/29/2007 10:16:59.010 lcid = 1033
03/29/2007 10:16:59.010 legalproductname = MSXML 6.0 Parser
03/29/2007 10:16:59.010 machinetype = x86
03/29/2007 10:16:59.010 package = HotFixMsxml6
03/29/2007 10:16:59.026 packagetype = Hotfix
03/29/2007 10:16:59.026 productcode = {A43BF6A5-D5F0-4AAA-BF41-65995063EC44}
03/29/2007 10:16:59.026 productname = Redist9
03/29/2007 10:16:59.026 recommendinstall = 1
03/29/2007 10:16:59.026 relatedlinks = <LCIDSUPPORTDIR>FinalSQL2005Information.rtf
03/29/2007 10:16:59.026 servicepackname = Microsoft SQL Server 2005 Service Pack 2 Setup
03/29/2007 10:16:59.026 splevel = 2
03/29/2007 10:16:59.026 sqladminprovisioningtool = <PROGRAMFILESDIR_WOW>Microsoft SQL Server90Sharedsqlprov.exe
03/29/2007 10:16:59.026 supportdir = D:Installs
03/29/2007 10:16:59.026 upgradecode = {1B117BA7-5BC1-419E-820E-7D4F3F412C7B}
03/29/2007 10:16:59.026 version = 9
03/29/2007 10:16:59.026
03/29/2007 10:16:59.026 File Group Details: MSI
03/29/2007 10:16:59.026 cachedmsipath = <PROGRAMFILESDIR>Microsoft SQL Server90Setup BootstrapCache
03/29/2007 10:16:59.026 sourcepath = <SUPPORTDIR><PACKAGE>Files
03/29/2007 10:16:59.026 File Details: msxml6.msi
03/29/2007 10:16:59.026
03/29/2007 10:16:59.026 Instance Details: MSXML 6.0 Parser
03/29/2007 10:16:59.026 fullversion = 6.10.1129.0
03/29/2007 10:16:59.026 lcid = 1033
03/29/2007 10:16:59.026 productcode = {A43BF6A5-D5F0-4AAA-BF41-65995063EC44}
03/29/2007 10:16:59.026 qfelevel = 1129
03/29/2007 10:16:59.026 sp = -1
03/29/2007 10:16:59.041
03/29/2007 10:16:59.041 Product Enumeration Results:
03/29/2007 10:16:59.041 INF File Name: D:InstallsHotFixMsxml6_x64.inf
03/29/2007 10:16:59.041 baselinebuild = 1399
03/29/2007 10:16:59.041 build = 6.10.1129.0
03/29/2007 10:16:59.041 description = MSXML 6.0 Parser
03/29/2007 10:16:59.041 details = Service Pack for Microsoft XML 6.0 Parser.
03/29/2007 10:16:59.041 installerlogpath = <PROGRAMFILESDIR>Microsoft SQL Server90Setup BootstrapLOGHotfix
03/29/2007 10:16:59.041 kbarticle = KB921896
03/29/2007 10:16:59.041 kbarticlehyperlink = http://support.microsoft.com/?kbid=921896
03/29/2007 10:16:59.041 lcid = 1033
03/29/2007 10:16:59.041 legalproductname = MSXML 6.0 Parser (64-bit)
03/29/2007 10:16:59.041 machinetype = x64
03/29/2007 10:16:59.041 package = HotFixMsxml6_x64
03/29/2007 10:16:59.041 packagetype = Hotfix
03/29/2007 10:16:59.041 productname = Redist9
03/29/2007 10:16:59.041 recommendinstall = 1
03/29/2007 10:16:59.041 relatedlinks = <LCIDSUPPORTDIR>FinalSQL2005Information.rtf
03/29/2007 10:16:59.041 servicepackname = Microsoft SQL Server 2005 Service Pack 2 Setup
03/29/2007 10:16:59.041 splevel = 2
03/29/2007 10:16:59.041 supportdir = D:Installs
03/29/2007 10:16:59.041 upgradecode = {5BBED1F8-E6F3-4A02-BC97-26D35BE200CA}
03/29/2007 10:16:59.041 version = 9
03/29/2007 10:16:59.057
03/29/2007 10:16:59.057 File Group Details: MSI
03/29/2007 10:16:59.057 cachedmsipath = <PROGRAMFILESDIR>Microsoft SQL Server90Setup BootstrapCache
03/29/2007 10:16:59.057 sourcepath = <SUPPORTDIR><PACKAGE>Files
03/29/2007 10:16:59.057 File Details: msxml6_x64.msi
03/29/2007 10:16:59.057
03/29/2007 10:16:59.057 Product Enumeration Results:
03/29/2007 10:16:59.057 INF File Name: D:InstallsHotFixSqlxml4.inf
03/29/2007 10:16:59.057 baselinebuild = 1399
03/29/2007 10:16:59.057 build = 3042
03/29/2007 10:16:59.057 description = SQLXML4
03/29/2007 10:16:59.057 details = Service Pack for Microsoft SQLXML 4.0.
03/29/2007 10:16:59.057 installerlogpath = <PROGRAMFILESDIR>Microsoft SQL Server90Setup BootstrapLOGHotfix
03/29/2007 10:16:59.057 kbarticle = KB921896
03/29/2007 10:16:59.057 kbarticlehyperlink = http://support.microsoft.com/?kbid=921896
03/29/2007 10:16:59.057 lcid = 1033
03/29/2007 10:16:59.057 legalproductname = SQLXML4
03/29/2007 10:16:59.057 machinetype = x86
03/29/2007 10:16:59.057 package = HotFixSqlxml4
03/29/2007 10:16:59.057 packagetype = Hotfix
03/29/2007 10:16:59.057 productcode = {36DD7006-7BFE-4E3D-AF6E-FA734BC879B7}
03/29/2007 10:16:59.057 productname = Redist9
03/29/2007 10:16:59.057 recommendinstall = 1
03/29/2007 10:16:59.057 relatedlinks = <LCIDSUPPORTDIR>FinalSQL2005Information.rtf
03/29/2007 10:16:59.072 servicepackname = Microsoft SQL Server 2005 Service Pack 2 Setup
03/29/2007 10:16:59.072 splevel = 2
03/29/2007 10:16:59.072 sqladminprovisioningtool = <PROGRAMFILESDIR_WOW>Microsoft SQL Server90Sharedsqlprov.exe
03/29/2007 10:16:59.072 supportdir = D:Installs
03/29/2007 10:16:59.072 upgradecode = {D9CA3D82-6F1B-41A7-8141-B90ACA8F865B}
03/29/2007 10:16:59.072 version = 9
03/29/2007 10:16:59.072
03/29/2007 10:16:59.072 File Group Details: MSI
03/29/2007 10:16:59.072 cachedmsipath = <PROGRAMFILESDIR>Microsoft SQL Server90Setup BootstrapCache
03/29/2007 10:16:59.072 sourcepath = <SUPPORTDIR><PACKAGE>Files
03/29/2007 10:16:59.072 File Details: sqlxml4.msi
03/29/2007 10:16:59.072
03/29/2007 10:16:59.072 Instance Details: SQLXML4
03/29/2007 10:16:59.072 fullversion = 9.00.3042.00
03/29/2007 10:16:59.072 lcid = 1033
03/29/2007 10:16:59.072 productcode = {36DD7006-7BFE-4E3D-AF6E-FA734BC879B7}
03/29/2007 10:16:59.072 qfelevel = 3042
03/29/2007 10:16:59.072 sp = -1
03/29/2007 10:16:59.072
03/29/2007 10:16:59.072 Product Enumeration Results:
03/29/2007 10:16:59.072 INF File Name: D:InstallsHotFixSqlxml4_x64.inf
03/29/2007 10:16:59.072 baselinebuild = 1399
03/29/2007 10:16:59.072 build = 3042
03/29/2007 10:16:59.088 description = SQLXML4
03/29/2007 10:16:59.088 details = Service Pack for Microsoft SQLXML 4.0.
03/29/2007 10:16:59.088 installerlogpath = <PROGRAMFILESDIR>Microsoft SQL Server90Setup BootstrapLOGHotfix
03/29/2007 10:16:59.088 kbarticle = KB921896
03/29/2007 10:16:59.088 kbarticlehyperlink = http://support.microsoft.com/?kbid=921896
03/29/2007 10:16:59.088 lcid = 1033
03/29/2007 10:16:59.088 legalproductname = SQLXML4 (64-bit)
03/29/2007 10:16:59.088 machinetype = x64
03/29/2007 10:16:59.088 package = HotFixSqlxml4_x64
03/29/2007 10:16:59.088 packagetype = Hotfix
03/29/2007 10:16:59.088 productname = Redist9
03/29/2007 10:16:59.088 recommendinstall = 1
03/29/2007 10:16:59.088 relatedlinks = <LCIDSUPPORTDIR>FinalSQL2005Information.rtf
03/29/2007 10:16:59.088 servicepackname = Microsoft SQL Server 2005 Service Pack 2 Setup
03/29/2007 10:16:59.088 splevel = 2
03/29/2007 10:16:59.088 supportdir = D:Installs
03/29/2007 10:16:59.088 upgradecode = {F457D8E6-7686-437D-9B17-E21D45CCABD8}
03/29/2007 10:16:59.088 version = 9
03/29/2007 10:16:59.088
03/29/2007 10:16:59.088 File Group Details: MSI
03/29/2007 10:16:59.088 cachedmsipath = <PROGRAMFILESDIR>Microsoft SQL Server90Setup BootstrapCache
03/29/2007 10:16:59.088 sourcepath = <SUPPORTDIR><PACKAGE>Files
03/29/2007 10:16:59.088 File Details: sqlxml4_x64.msi
03/29/2007 10:16:59.104
03/29/2007 10:16:59.104 Product Enumeration Results:
03/29/2007 10:16:59.104 INF File Name: D:InstallsHotFixSQLServer2005_BC.inf
03/29/2007 10:16:59.104 baselinebuild = 1399
03/29/2007 10:16:59.104 build = 2004
03/29/2007 10:16:59.104 description = Backward Compatibility
03/29/2007 10:16:59.104 details = Service Pack for the Backward Compatibility components, including Data Transformation Services Runtime and SQL-DMO.
03/29/2007 10:16:59.104 installerlogpath = <PROGRAMFILESDIR>Microsoft SQL Server90Setup BootstrapLOGHotfix
03/29/2007 10:16:59.104 kbarticle = KB921896
03/29/2007 10:16:59.104 kbarticlehyperlink = http://support.microsoft.com/?kbid=921896
03/29/2007 10:16:59.104 lcid = 1033
03/29/2007 10:16:59.104 legalproductname = Microsoft SQL Server 2005 Backward Compatibility
03/29/2007 10:16:59.104 machinetype = x86
03/29/2007 10:16:59.104 package = HotFixSQLServer2005_BC
03/29/2007 10:16:59.104 packagetype = Hotfix
03/29/2007 10:16:59.104 productcode = {69880C00-08DD-4385-B752-9C62656F6D1E}
03/29/2007 10:16:59.104 productname = Redist9
03/29/2007 10:16:59.104 recommendinstall = 1
03/29/2007 10:16:59.104 relatedlinks = <LCIDSUPPORTDIR>FinalSQL2005Information.rtf
03/29/2007 10:16:59.104 servicepackname = Microsoft SQL Server 2005 Service Pack 2 Setup
03/29/2007 10:16:59.104 splevel = 2
03/29/2007 10:16:59.104 sqladminprovisioningtool = <PROGRAMFILESDIR_WOW>Microsoft SQL Server90Sharedsqlprov.exe
03/29/2007 10:16:59.104 supportdir = D:Installs
03/29/2007 10:16:59.119 upgradecode = {1E70C6C9-E1B7-4A74-BC8C-8EB5D010CEC9}
03/29/2007 10:16:59.119 version = 9
03/29/2007 10:16:59.119
03/29/2007 10:16:59.119 File Group Details: MSI
03/29/2007 10:16:59.119 cachedmsipath = <PROGRAMFILESDIR>Microsoft SQL Server90Setup BootstrapCache
03/29/2007 10:16:59.119 sourcepath = <SUPPORTDIR><PACKAGE>Files
03/29/2007 10:16:59.119 File Details: SQLServer2005_BC.msi
03/29/2007 10:16:59.119
03/29/2007 10:16:59.119 Instance Details: Backward Compatibility
03/29/2007 10:16:59.119 fullversion = 8.05.2004
03/29/2007 10:16:59.119 lcid = 1033
03/29/2007 10:16:59.119 productcode = {69880C00-08DD-4385-B752-9C62656F6D1E}
03/29/2007 10:16:59.119 qfelevel = 2004
03/29/2007 10:16:59.119 sp = -1
03/29/2007 10:16:59.119
03/29/2007 10:16:59.119 Product Enumeration Results:
03/29/2007 10:16:59.119 INF File Name: D:InstallsHotFixSQLServer2005_BC_x64.inf
03/29/2007 10:16:59.119 baselinebuild = 1399
03/29/2007 10:16:59.119 build = 2004
03/29/2007 10:16:59.119 description = Backward Compatibility
03/29/2007 10:16:59.119 details = Service Pack for the Backward Compatibility components, including Data Transformation Services Runtime and SQL-DMO.
03/29/2007 10:16:59.119 installerlogpath = <PROGRAMFILESDIR>Microsoft SQL Server90Setup BootstrapLOGHotfix
03/29/2007 10:16:59.135 kbarticle = KB921896
03/29/2007 10:16:59.135 kbarticlehyperlink = http://support.microsoft.com/?kbid=921896
03/29/2007 10:16:59.135 lcid = 1033
03/29/2007 10:16:59.135 legalproductname = Microsoft SQL Server 2005 Backward Compatibility (64-bit)
03/29/2007 10:16:59.135 machinetype = x64
03/29/2007 10:16:59.135 package = HotFixSQLServer2005_BC_x64
03/29/2007 10:16:59.135 packagetype = Hotfix
03/29/2007 10:16:59.135 productname = Redist9
03/29/2007 10:16:59.135 recommendinstall = 1
03/29/2007 10:16:59.135 relatedlinks = <LCIDSUPPORTDIR>FinalSQL2005Information.rtf
03/29/2007 10:16:59.135 servicepackname = Microsoft SQL Server 2005 Service Pack 2 Setup
03/29/2007 10:16:59.135 splevel = 2
03/29/2007 10:16:59.135 supportdir = D:Installs
03/29/2007 10:16:59.135 upgradecode = {7B6BF434-3C72-4DB3-8049-FEF31AEAFF9A}
03/29/2007 10:16:59.135 version = 9
03/29/2007 10:16:59.135
03/29/2007 10:16:59.135 File Group Details: MSI
03/29/2007 10:16:59.135 cachedmsipath = <PROGRAMFILESDIR>Microsoft SQL Server90Setup BootstrapCache
03/29/2007 10:16:59.135 sourcepath = <SUPPORTDIR><PACKAGE>Files
03/29/2007 10:16:59.135 File Details: SQLServer2005_BC_x64.msi
03/29/2007 10:16:59.135
03/29/2007 10:16:59.135 Product Enumeration Results:
03/29/2007 10:16:59.135 INF File Name: D:InstallsHotFixSqlWriter.inf
03/29/2007 10:16:59.135 baselinebuild = 1399
03/29/2007 10:16:59.151 build = 3042
03/29/2007 10:16:59.151 description = Microsoft SQL Server VSS Writer
03/29/2007 10:16:59.151 details = Service Pack for Microsoft SQL Server VSS Writer.
03/29/2007 10:16:59.151 installerlogpath = <PROGRAMFILESDIR>Microsoft SQL Server90Setup BootstrapLOGHotfix
03/29/2007 10:16:59.151 kbarticle = KB921896
03/29/2007 10:16:59.151 kbarticlehyperlink = http://support.microsoft.com/?kbid=921896
03/29/2007 10:16:59.151 lcid = 1033
03/29/2007 10:16:59.151 legalproductname = Microsoft SQL Server VSS Writer
03/29/2007 10:16:59.151 machinetype = x86
03/29/2007 10:16:59.151 package = HotFixSqlWriter
03/29/2007 10:16:59.151 packagetype = Hotfix
03/29/2007 10:16:59.151 productcode = {E9F44C98-B8B6-480F-AF7B-E42A0A46F4E3}
03/29/2007 10:16:59.151 productname = Redist9
03/29/2007 10:16:59.151 recommendinstall = 1
03/29/2007 10:16:59.151 relatedlinks = <LCIDSUPPORTDIR>FinalSQL2005Information.rtf
03/29/2007 10:16:59.151 servicepackname = Microsoft SQL Server 2005 Service Pack 2 Setup
03/29/2007 10:16:59.151 splevel = 2
03/29/2007 10:16:59.151 sqladminprovisioningtool = <PROGRAMFILESDIR_WOW>Microsoft SQL Server90Sharedsqlprov.exe
03/29/2007 10:16:59.151 supportdir = D:Installs
03/29/2007 10:16:59.151 upgradecode = {65D8E1DF-6201-4B53-A0F9-E654F8E80F97}
03/29/2007 10:16:59.151 version = 9
03/29/2007 10:16:59.151
03/29/2007 10:16:59.151 File Group Details: MSI
03/29/2007 10:16:59.166 cachedmsipath = <PROGRAMFILESDIR>Microsoft SQL Server90Setup BootstrapCache
03/29/2007 10:16:59.166 sourcepath = <SUPPORTDIR><PACKAGE>Files
03/29/2007 10:16:59.166 File Details: SqlWriter.msi
03/29/2007 10:16:59.166
03/29/2007 10:16:59.166 Instance Details: Microsoft SQL Server VSS Writer
03/29/2007 10:16:59.166 fullversion = 9.00.3042.00
03/29/2007 10:16:59.166 lcid = 1033
03/29/2007 10:16:59.166 productcode = {E9F44C98-B8B6-480F-AF7B-E42A0A46F4E3}
03/29/2007 10:16:59.166 qfelevel = 3042
03/29/2007 10:16:59.166 sp = -1
03/29/2007 10:16:59.166
03/29/2007 10:16:59.166 Product Enumeration Results:
03/29/2007 10:16:59.166 INF File Name: D:InstallsHotFixSqlWriter_x64.inf
03/29/2007 10:16:59.166 baselinebuild = 1399
03/29/2007 10:16:59.166 build = 3042
03/29/2007 10:16:59.166 description = Microsoft SQL Server VSS Writer
03/29/2007 10:16:59.166 details = Service Pack for Microsoft SQL Server VSS Writer.
03/29/2007 10:16:59.166 installerlogpath = <PROGRAMFILESDIR>Microsoft SQL Server90Setup BootstrapLOGHotfix
03/29/2007 10:16:59.166 kbarticle = KB921896
03/29/2007 10:16:59.166 kbarticlehyperlink = http://support.microsoft.com/?kbid=921896
03/29/2007 10:16:59.166 lcid = 1033
03/29/2007 10:16:59.166 legalproductname = Microsoft SQL Server VSS Writer (64-bit)
03/29/2007 10:16:59.166 machinetype = x64
03/29/2007 10:16:59.182 package = HotFixSqlWriter_x64
03/29/2007 10:16:59.182 packagetype = Hotfix
03/29/2007 10:16:59.182 productname = Redist9
03/29/2007 10:16:59.182 recommendinstall = 1
03/29/2007 10:16:59.182 relatedlinks = <LCIDSUPPORTDIR>FinalSQL2005Information.rtf
03/29/2007 10:16:59.182 servicepackname = Microsoft SQL Server 2005 Service Pack 2 Setup
03/29/2007 10:16:59.182 splevel = 2
03/29/2007 10:16:59.182 supportdir = D:Installs
03/29/2007 10:16:59.182 upgradecode = {E9031696-DD39-4C25-BAEB-425FF28279EA}
03/29/2007 10:16:59.182 version = 9
03/29/2007 10:16:59.182
03/29/2007 10:16:59.182 File Group Details: MSI
03/29/2007 10:16:59.182 cachedmsipath = <PROGRAMFILESDIR>Microsoft SQL Server90Setup BootstrapCache
03/29/2007 10:16:59.182 sourcepath = <SUPPORTDIR><PACKAGE>Files
03/29/2007 10:16:59.182 File Details: SqlWriter_x64.msi
03/29/2007 10:16:59.182
03/29/2007 10:17:27.916 Registry: Opened registry key "SystemCurrentControlSetControlSession Manager"
03/29/2007 10:17:27.916 Registry: Cannot read registry key value "PendingFileRenameOperations"
03/29/2007 10:17:27.931 Registry: Read registry key value "EnableErrorReporting", DWORD value = 0
03/29/2007 10:17:27.947 Registry: Read registry key value "CustomerFeedBack", DWORD value = 0
03/29/2007 10:17:41.838 Registry: Set registry key value "EnableErrorReporting", DWORD value = 1
03/29/2007 10:17:41.838 Registry: Set registry key value "CustomerFeedBack", DWORD value = 0
03/29/2007 10:17:41.884 Locked file: Checking for locked files
03/29/2007 10:17:45.744 Locked file: C:Program Filesmicrosoft sql server90dtsinnmsdtssrvr.exe (MsDtsServer [MsDtsSrvr.exe] - 8060)
03/29/2007 10:53:18.873 Locked file: Checking for locked files
03/29/2007 10:53:26.482 Attempting to pause the 32 bit ngen queue
03/29/2007 10:53:27.294 Installing product: NS9
03/29/2007 10:53:27.294 Installing instance: NS
03/29/2007 10:53:27.310 Installing target: BPATLQQDW
03/29/2007 10:53:27.310 Installing file: sqlrun_ns.msp
03/29/2007 10:53:27.326 Copy Engine: Creating MSP install log file at: C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixNS9_Hotfix_KB921896_sqlrun_ns.msp.log
03/29/2007 10:53:27.326 Registry: Opened registry key "SoftwarePoliciesMicrosoftWindowsInstaller"
03/29/2007 10:53:27.326 Registry: Cannot read registry key value "Debug"
03/29/2007 10:53:27.873 MSP returned 1612: The installation source for this product is not available. Verify that the source exists and that you can access it.
03/29/2007 10:53:27.873 Registry: Opened registry key "SoftwarePoliciesMicrosoftWindowsInstaller"
03/29/2007 10:53:27.873 Registry: Cannot read registry key value "Debug"
03/29/2007 10:53:27.888 Copy Engine: Error, unable to install MSP file: D:InstallsHotFixNSFilessqlrun_ns.msp
03/29/2007 10:53:27.888 The following exception occurred: Unable to install Windows Installer MSP file Date: 03/29/2007 10:53:27.888 File: depotsqlvaultstablesetupmainl1setupsqlsesql
ok...i give up.....
can this be done? (sql server 2000)
all i want to do is have my stored procedure output some data to a file and i want the filename to include a time stamp.
here's my current working file output code:
EXEC master..xp_cmdshell 'bcp "select * from CEData..employee" queryout "c:employees.txt" -c -Usa -P'
i'd like it to be something like this:
EXEC master..xp_cmdshell 'bcp "select * from CEData..employee" queryout "c:employees" + datetime + ".txt" -c -Usa -P'
but nothing seems to work.
We have an application group that wants to pull date from SQL Server and write it to text file on the server. They want the file format to be 12100_YYYMMDDHHMM.fr1 for one set of data, 12100_YYYMMDDHHMM.fr2 for a second set...and so on. The '12100' is fixed, but the rest of the file name will always have to include the system date/time. Is there an easy way to do this within a DTS package (when writing to the output file)? I would really appreciate help on this. Thank you.
View 1 Replies View RelatedHi
I am trying to move a flat file to an archive folder and then rename the file to include the date and time of runtime.
I have set up a File System Task to move the file which works fine and a second File System Task to rename. The IsDestinationPathVariable is set to TRUE and the DestinationVariable is called User::Error_Log_File_Rename. There is an expression as follows:
@[User::Error_Log_File_Rename] = "Y:\SSIS_PUD_Upload\Error_Log_Archive\Update_Error_Messages - " +REPLACE((DT_WSTR, 30)(DT_DBDATE)GETDATE() + "-" + (DT_WSTR, 30)(DT_DBTIME)GETDATE(),":","-") +".txt"
which is the required file name.
If I go into the expression and evaluate it it will give me the current date and time. However when I run it as part of the package say 10 minutes later the file is renamed using the same date and time from 10 minutes before when I evaluated the expression. If I wait another 10 minutes and run the package again it still retains the original date and time.
Is there a way to get the expression evaluated with the current date and time during execution of the package?
Thanks in advance
Scott
I have set up an export package in SSIS and I would like to assign a file name based on the value in a table on my SQLServer. For example, my file name might be Monthly Reporting Package 20070731.xls where 20070731 is a value in my date table. I can retrieve my date by the following select statement: "SELECT Date FROM DecodeTables.dbo.Date". Can I set up a variable to look up this value and then concatenate it into my file name?
View 3 Replies View RelatedI want to import date from excel file from the row if this row has a character like 'TableName', and I don't know the rownumber and end column number ,so I can't use openrowset 'select * from Sheet$ A11:N'. And I am thing if I can get the rownumber of the row contain string 'TableName' and the max column ,that May be easy to extract data.
View 2 Replies View RelatedHi,
I am looking for tutorials about how to create dts et dtsx files.
Thanks for your help.
Arioule.
Ok, I am stumped.
On a clean Windows Server 2003 machine we installed SQL Server 2005 Enterprise edition.
We then installed all of the components, including BIDS. however, there is no option to start BIDS and I see devenv.exe does not exist.
Do I need VS installed in order to run BIDS and SSIS?
Thanks for any help!
Pete Verrone
Hi
I have installed SQL Server 2005 but Integration Services is just not there. I have uninstalled and reinstalled several times and in the process uninstalled an old version of Visual Studio.NET (manually because it wouldn't uninstall automatically) and Visual Web Developer, just in case they were interfering with Integration Services. No luck, in fact it got worse, now Analysis Services also does not work because it can't find devenv.exe!
I have installed exactly this same software on another clean PC (ie. no previous Visual Studio variants on it) and it installs perfectly.
There seems to be some kind of clash between old versions of Visual Studio and SQL Server 2005 that prevents SQL Server from properly installing products like Integration Services that use the Visual Studio interface (ie. devenv.exe).
I now can't even reinstall the old version of Visual Studio.NET, and devenv.exe is nowhere to be found on my PC although it is referenced throughout the registry.
Has anyone got any suggestions, all I am after if a full and clean install of SQL Server 2005 so I can develop against it using Visual Web Developer.
Thanks
Can someone tell me how to install SSIS?
I've gone through Add/Remove programs, and attempted to update SQL Server 2005 but cannot seem to find the correct components to add, and since I cannot see the SSIS name in my Services panel, i assume it hasn't been installed.
I note that I can install SSIS on a client box not just a server. What is the advantage (expect maybe if the client is a portable computer) to installing SSIS on a client box? I would normally expect to find it running on the server side of the house.
TIA,
Barkingdog
Hi,
I have sql server 2005 express and toolkits installed. However, I only see Report Server projects in my Visual Studio 2005 when I choose a Business Intelligence project.
Will someone please help me download the right file to start using SSIS designer?
Thanks,
Jae
Can anyone give me the command line text to install an mdf file? I have a file called contacts.mdf from a Microsoft book and need to install it to MSDE in order to complete the examples in the book.
Thanks in advance.
I have used above the DTSInstall.exe to Install my DTS Package in SQL Server 2005.
An entry is created in the sysdtspackages90 table.
2 Questions:
1)Where in SQL Server 2005 should I be able to see the Package itself? If I look in Maintenace Plans I see nothing.
2) If I want to run it manually, when I double click on the dtsx file on the Database Server I get a message asking me what program I want to open it with? Why is this? Do I need to have SQL Management Studio Installed?
Any help apprecisated.
How can we install the SSIS runtime components alone.
We are calling SSIS packages from .NET code. We would like to know what are the minimum components we need to install in the machine in which the .NET code is running.
Thanks,
Loonysan
how i will can create a install for SSIS package
View 3 Replies View RelatedI'm trying to reinstall SQL Server 2005 STD but I cannot get Setup to install Integration Services or Notification Services. I looked in the log and this is what I found. Needless to say, it makes no sense to me. It seems that Setup is trying to find a missing source list for a certain product. I have no clue what that product is. I've spent endless hours trying to figure it out and I'm still drawing a blank. This is a printout of the log.
Integration services -
----------------------
MSI (s) (F0:B0) [02:33:01:437]: Machine policy value 'DisableUserInstalls' is 0
MSI (s) (F0:B0) [02:33:02:188]: End dialog not enabled
MSI (s) (F0:B0) [02:33:02:188]: Original package ==> G:ServersSetupSqlRun_DTS.msi
MSI (s) (F0:B0) [02:33:02:188]: Package we're running from ==> C:WINDOWSInstaller188966.msi
MSI (s) (F0:B0) [02:33:02:339]: APPCOMPAT: looking for appcompat database entry with ProductCode '{EE8CFFD9-6E29-4DC3-A967-7348D5F41F44}'.
MSI (s) (F0:B0) [02:33:02:339]: APPCOMPAT: no matching ProductCode found in database.
MSI (s) (F0:B0) [02:33:02:339]: MSCOREE already loaded, using loaded copy
MSI (s) (F0:B0) [02:33:02:379]: Couldn't find local patch ''. Looking for it at its source.
MSI (s) (F0:B0) [02:33:02:379]: Resolving Patch source.
MSI (s) (F0:B0) [02:33:02:379]: User policy value 'SearchOrder' is 'nmu'
MSI (s) (F0:B0) [02:33:02:379]: User policy value 'DisableMedia' is 0
MSI (s) (F0:B0) [02:33:02:379]: Machine policy value 'AllowLockdownMedia' is 0
MSI (s) (F0:B0) [02:33:02:379]: SOURCEMGMT: Media enabled only if package is safe.
MSI (s) (F0:B0) [02:33:02:379]: SOURCEMGMT: Looking for sourcelist for product {8B7E2749-624E-4C61-92FC-2BC18307FF24}
MSI (s) (F0:B0) [02:33:02:379]: Note: 1: 1706 2: {8B7E2749-624E-4C61-92FC-2BC18307FF24} 3:
MSI (s) (F0:B0) [02:33:02:379]: SOURCEMGMT: Failed to resolve source
MSI (s) (F0:B0) [02:33:02:399]: Note: 1: 1708
MSI (s) (F0:B0) [02:33:02:399]: Note: 1: 2729
MSI (s) (F0:B0) [02:33:02:409]: Note: 1: 2729
MSI (s) (F0:B0) [02:33:02:409]: Product: Microsoft SQL Server 2005 Integration Services -- Installation failed.
MSI (s) (F0:B0) [02:33:02:439]: MainEngineThread is returning 1612
The installation source for this product is not available. Verify that the source exists and that you can access it.
G:ServersSetupSqlRun_DTS.msi
MSI (c) (B8:88) [02:33:02:439]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (c) (B8:88) [02:33:02:439]: MainEngineThread is returning 1612
=== Verbose logging stopped: 5/19/2006 2:33:02 ===
-----------------------
Notification services -
-----------------------
MSI (s) (F0:30) [02:33:07:566]: Machine policy value 'DisableUserInstalls' is 0
MSI (s) (F0:30) [02:33:08:087]: End dialog not enabled
MSI (s) (F0:30) [02:33:08:087]: Original package ==> G:ServersSetupSqlRun_NS.msi
MSI (s) (F0:30) [02:33:08:087]: Package we're running from ==> C:WINDOWSInstaller18898f.msi
MSI (s) (F0:30) [02:33:08:167]: APPCOMPAT: looking for appcompat database entry with ProductCode '{37E9AD9F-3217-4229-B5A5-7A0C82364C6C}'.
MSI (s) (F0:30) [02:33:08:167]: APPCOMPAT: no matching ProductCode found in database.
MSI (s) (F0:30) [02:33:08:167]: MSCOREE already loaded, using loaded copy
MSI (s) (F0:30) [02:33:08:187]: Couldn't find local patch ''. Looking for it at its source.
MSI (s) (F0:30) [02:33:08:187]: Resolving Patch source.
MSI (s) (F0:30) [02:33:08:187]: User policy value 'SearchOrder' is 'nmu'
MSI (s) (F0:30) [02:33:08:187]: User policy value 'DisableMedia' is 0
MSI (s) (F0:30) [02:33:08:187]: Machine policy value 'AllowLockdownMedia' is 0
MSI (s) (F0:30) [02:33:08:187]: SOURCEMGMT: Media enabled only if package is safe.
MSI (s) (F0:30) [02:33:08:187]: SOURCEMGMT: Looking for sourcelist for product {65A498A6-83B9-4B91-99EA-1BA88D73F0AA}
MSI (s) (F0:30) [02:33:08:187]: Note: 1: 1706 2: {65A498A6-83B9-4B91-99EA-1BA88D73F0AA} 3:
MSI (s) (F0:30) [02:33:08:187]: SOURCEMGMT: Failed to resolve source
MSI (s) (F0:30) [02:33:08:187]: Note: 1: 1708
MSI (s) (F0:30) [02:33:08:187]: Note: 1: 2729
MSI (s) (F0:30) [02:33:08:187]: Note: 1: 2729
MSI (s) (F0:30) [02:33:08:187]: Product: Microsoft SQL Server 2005 Notification Services -- Installation failed.
MSI (s) (F0:30) [02:33:08:197]: MainEngineThread is returning 1612
The installation source for this product is not available. Verify that the source exists and that you can access it.
G:ServersSetupSqlRun_NS.msi
MSI (c) (B8:DC) [02:33:08:207]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (c) (B8:DC) [02:33:08:207]: MainEngineThread is returning 1612
Hi,
We just moved from SQL 2000 to SQL 2005 Ent. To use SSIS service, I need install this package on client side. But when I install the 2005 on my PC(Win XP Prof), I did not find any place I can include it. Anyone has similar experience or know how to do it?
Thanks in advance,
Jie
I have only SQL engine installed to my D drive. (SQL Server 2005 no SP1)
I want to install SSIS to my D drive but i can not.
It only gives me the option to install to the default drive C:...
saying that "the sql shared path has already been configured"
Is this a BUG ?
No Tools nor Notification Services are installed (which i understood to be related to the same path as SSIS)
thanks,
raviv
It's possible to install a SSIS package on a server running SQL Express 2005?
View 1 Replies View RelatedI asked this before and was told that it was an option on setup, but for the life of my I can't find it.
I have a requirement for all the transaction logs to go to a separate drive (L:), I would like to be able to specify this location as part of the install but I don't see the option. I have been successful doing so after the install but it is a bit annoying to have to do it that way when it seems like the install should have this option.
I am reaching out once more to see if anyone can tell me if I am missing something in the install process that will allow me to do this?
Thanks in advance.
Future guru in the making.
Hello,
I have a requirement to have all the transaction logs for our SQL Server databases go to a drive letter L: - I would like to do this during the install process but I don't see any way to specify in the setup. I am able to go in and do it after the install but it is a bit of a pain to do.
Anyone know how I can do this in the install itself?
I used the SSIS tutorial just fine with no problems. But then I installed SP1 for SQL2005 and now in the Collection screen for a Foreach Loop Container I no longer have an option for Foreach File Enumerator in the drop down for enumerators. Any suggestions or fixes?
View 12 Replies View RelatedHello Experts,
I am createing one task (user control) in SSIS. I have property grid in my GUI and 2 buttons (OK & Cancle).
PropertyGrid has Properties like SourceConnection, OutputConnection etc....right now I am able to populate Connections in list box next to Source and Output Property.
Now my question to you guys is depending on Source Connection it should read that text file associated with connection manager. After validation it should pick header (first line of text file bases on record type) and write it into new file when task is executed. I have following code for your reference. Please let me know I am going in right direction or not..
What should go here ?
->Under Class A
public override DTSExecResult Execute(Connections connections, VariableDispenser variableDispenser, IDTSComponentEvents componentEvents, IDTSLogging log, object transaction)
{
//Some code to read file and write it into new file
return DTSExecResult.Success;
}
public const string Property_Task = "CustomErrorControl";
public const string Property_SourceConnection = "SourceConnection";
public void LoadFromXML(XmlElement node, IDTSInfoEvents infoEvents)
{
if (node.Name != Property_Task)
{
throw new Exception(String.Format("Invalid task element '{0}' in LoadFromXML.", node.Name));
}
else
{
try
{
_sourceConnectionId = node.Attributes.GetNamedItem(Property_SourceConnection).Value;
}
catch (Exception ex)
{
infoEvents.FireError(0, "LoadFromXML", ex.Message, "", 0);
}
}
}
public void SaveToXML(XmlDocument doc, IDTSInfoEvents infoEvents)
{
try
{
// // Create Task Element
XmlElement taskElement = doc.CreateElement("", Property_Task, "");
doc.AppendChild(taskElement);
// // Save source FileConnection
XmlAttribute sourcefileAttribute = doc.CreateAttribute(Property_SourceConnection);
sourcefileAttribute.Value = _sourceConnectionId;
taskElement.Attributes.Append(sourcefileAttribute);
}
catch (Exception ex)
{
infoEvents.FireError(0, "SaveXML", ex.Message, "", 0);
}
}
In UI Class there is OK Click event.
private void btnOK_Click(object sender, EventArgs e)
{
try
{
_taskHost.Properties[CustomErrorControl.Property_SourceConnection].SetValue(_taskHost, propertyGrid1.Text);
btnOK.DialogResult = DialogResult.OK;
}
catch (Exception ex)
{
Console.WriteLine(ex);
}
#endregion
}
I want to enumerate all *.xls and *.csv file. How to fill the Files box? I tried
*.xls, *.csv
*.xls *.csv
*.(xls|cvs)
all doesn't work
Hi all,
In a foreachloop, I am inserting records into a flat file which is working fine. But the thing is that as the file grows, it takes longer for it to locate the EOF(End of File) of the flat file so as to insert the records.
I have around 70-100 lines written to the file at each loop and there are more than 20k records to be looped. wihich means that at the end I should be having 1400k - 20000k line in the text file.
One solution would be to insert the records at the start of the file itself so that it does not has to lookup the EOF each time before writting.
Another would be to generate separate files and then merge it.
Any idea how can this can be done?
Beside this I have to zip the file and then SFTP to a given address.
Any suggestion or help would be welcome.
Rdgs
David
Historically I've always written a VB script to copy a file from a sharepoint library. I don't like this method because I have to input a username & password in the script and maintain a config file.
Yesterday I was playing around with using a file system task. The sharepoint file has a UNC path so why not? I created a simple test package with a single file system task that copies the sharepoint file (addressed via UNC) to another network location. Package runs fine locally.
I try running on our utility server but am getting a "The file name [SHAREPOINT UNC PATH] specified in the connection was not valid" error. Package is running with a proxy on the server and the proxy account has the same permissions to the sharepoint site (so far as I can tell) as me.
I am trying to create and later read a data file from a package deployed in SSISDB, but it is not reading it while it is successfully creating the file. The same package when run from the file system package, runs successfully. Generating ispac and deploying in SSISDB is running for infinite time. Is it a permission issue?
View 7 Replies View RelatedTrying to install SQL Server 2005 Express and can't get SSIS to install - I keep getting message that IIS is not installed or enabled, however IIS 7.0 is installed and all features are enabled. I'm running VISTA home premium. Is this the problem?
Quick question :
We are installing 2 instances of sql server in cluster env.
When intalling "Default" instance, I m getting Notification services, Integration, reporting services for default instance.
My question is : When we intall second named instance on cluster, will named instance share Notification services, Integration, reporting services with default instace.
So if above is yes, do I have to install Notification services, Integration, reporting services on C: drive of cluster nodes, so that it is shared by all the instances on the cluster nodes.
Please give some description on this.
Thanks
HI,
i have one instalation file of SQL CE 2.0 named setup.exe ,i installed that in my desktop it works well.i could not install the same file inside the pocketPC.Can any one give me some information about how to get the installation file of SQL CE 2.0 and how to install that in real pocketPC.Thanks in advance.
Best Regards
Ihsan