我正在尝试在我们的生产 SQL 2005 SP2 机器上安装 SSIS。每次我尝试，安装/设置屏幕都会导致失败，从本机客户端开始，然后向下移动。下面的屏幕截图显示了我看到的内容：
安装失败后，点击本机客户端右侧的状态链接的结果如下：
=== Verbose logging started: 3/28/2012 16:38:08 Build type: SHIP UNICODE 3.01.4000.4042 Calling process: C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\setup.exe ===
MSI (c) (DC:00) [16:38:08:875]: Resetting cached policy values
MSI (c) (DC:00) [16:38:08:875]: Machine policy value 'Debug' is 0
MSI (c) (DC:00) [16:38:08:875]: ******* RunEngine:
******* Product: {F9B3DD02-B0B3-42E9-8650-030DFF0D133D}
******* Action:
******* CommandLine: **********
MSI (c) (DC:00) [16:38:08:875]: Client-side and UI is none or basic: Running entire install on the server.
MSI (c) (DC:00) [16:38:08:875]: Grabbed execution mutex.
MSI (c) (DC:00) [16:38:08:875]: Cloaking enabled.
MSI (c) (DC:00) [16:38:08:875]: Attempting to enable all disabled priveleges before calling Install on Server
MSI (c) (DC:00) [16:38:08:875]: Incrementing counter to disable shutdown. Counter after increment: 0
MSI (s) (90:F0) [16:38:08:875]: Grabbed execution mutex.
MSI (s) (90:D4) [16:38:08:875]: Resetting cached policy values
MSI (s) (90:D4) [16:38:08:875]: Machine policy value 'Debug' is 0
MSI (s) (90:D4) [16:38:08:875]: ******* RunEngine:
******* Product: {F9B3DD02-B0B3-42E9-8650-030DFF0D133D}
******* Action:
******* CommandLine: **********
MSI (s) (90:D4) [16:38:08:875]: Machine policy value 'DisableUserInstalls' is 0
MSI (s) (90:D4) [16:38:08:890]: Warning: Local cached package 'C:\WINDOWS\Installer\65eb99.msi' is missing.
MSI (s) (90:D4) [16:38:08:890]: User policy value 'SearchOrder' is 'nmu'
MSI (s) (90:D4) [16:38:08:890]: User policy value 'DisableMedia' is 0
MSI (s) (90:D4) [16:38:08:890]: Machine policy value 'AllowLockdownMedia' is 0
MSI (s) (90:D4) [16:38:08:890]: SOURCEMGMT: Media enabled only if package is safe.
MSI (s) (90:D4) [16:38:08:890]: SOURCEMGMT: Looking for sourcelist for product {F9B3DD02-B0B3-42E9-8650-030DFF0D133D}
MSI (s) (90:D4) [16:38:08:890]: SOURCEMGMT: Adding {F9B3DD02-B0B3-42E9-8650-030DFF0D133D}; to potential sourcelist list (pcode;disk;relpath).
MSI (s) (90:D4) [16:38:08:890]: SOURCEMGMT: Now checking product {F9B3DD02-B0B3-42E9-8650-030DFF0D133D}
MSI (s) (90:D4) [16:38:08:890]: SOURCEMGMT: Media is enabled for product.
MSI (s) (90:D4) [16:38:08:890]: SOURCEMGMT: Attempting to use LastUsedSource from source list.
MSI (s) (90:D4) [16:38:08:890]: SOURCEMGMT: Trying source C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\Cache\.
MSI (s) (90:D4) [16:38:08:890]: SOURCEMGMT: Source is invalid due to invalid package code (product code doesn't match).
MSI (s) (90:D4) [16:38:08:890]: Note: 1: 1706 2: -2147483646 3: sqlncli.msi
MSI (s) (90:D4) [16:38:08:890]: SOURCEMGMT: Processing net source list.
MSI (s) (90:D4) [16:38:08:890]: Note: 1: 1706 2: -2147483647 3: sqlncli.msi
MSI (s) (90:D4) [16:38:08:890]: SOURCEMGMT: Processing media source list.
MSI (s) (90:D4) [16:38:09:921]: SOURCEMGMT: Trying media source F:\.
MSI (s) (90:D4) [16:38:09:921]: Note: 1: 2203 2: F:\sqlncli.msi 3: -2147287038
MSI (s) (90:D4) [16:38:09:921]: SOURCEMGMT: Source is invalid due to missing/inaccessible package.
MSI (s) (90:D4) [16:38:09:921]: Note: 1: 1706 2: -2147483647 3: sqlncli.msi
MSI (s) (90:D4) [16:38:09:921]: SOURCEMGMT: Processing URL source list.
MSI (s) (90:D4) [16:38:09:921]: Note: 1: 1402 2: UNKNOWN\URL 3: 2
MSI (s) (90:D4) [16:38:09:921]: Note: 1: 1706 2: -2147483647 3: sqlncli.msi
MSI (s) (90:D4) [16:38:09:921]: Note: 1: 1706 2: 3: sqlncli.msi
MSI (s) (90:D4) [16:38:09:921]: SOURCEMGMT: Failed to resolve source
MSI (s) (90:D4) [16:38:09:921]: MainEngineThread is returning 1612
MSI (c) (DC:00) [16:38:09:921]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (c) (DC:00) [16:38:09:921]: MainEngineThread is returning 1612
=== Verbose logging stopped: 3/28/2012 16:38:09 ===
当我单击 MSXML6 的失败状态时可见的日志如下：
=== Verbose logging started: 3/28/2012 16:38:12 Build type: SHIP UNICODE 3.01.4000.4042 Calling process: C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\setup.exe ===
MSI (c) (DC:58) [16:38:12:250]: Resetting cached policy values
MSI (c) (DC:58) [16:38:12:250]: Machine policy value 'Debug' is 0
MSI (c) (DC:58) [16:38:12:250]: ******* RunEngine:
******* Product: {56EA8BC0-3751-4B93-BC9D-6651CC36E5AA}
******* Action:
******* CommandLine: **********
MSI (c) (DC:58) [16:38:12:250]: Client-side and UI is none or basic: Running entire install on the server.
MSI (c) (DC:58) [16:38:12:250]: Grabbed execution mutex.
MSI (c) (DC:58) [16:38:12:250]: Cloaking enabled.
MSI (c) (DC:58) [16:38:12:250]: Attempting to enable all disabled priveleges before calling Install on Server
MSI (c) (DC:58) [16:38:12:250]: Incrementing counter to disable shutdown. Counter after increment: 0
MSI (s) (90:58) [16:38:12:265]: Grabbed execution mutex.
MSI (s) (90:DC) [16:38:12:265]: Resetting cached policy values
MSI (s) (90:DC) [16:38:12:265]: Machine policy value 'Debug' is 0
MSI (s) (90:DC) [16:38:12:265]: ******* RunEngine:
******* Product: {56EA8BC0-3751-4B93-BC9D-6651CC36E5AA}
******* Action:
******* CommandLine: **********
MSI (s) (90:DC) [16:38:12:265]: Machine policy value 'DisableUserInstalls' is 0
MSI (s) (90:DC) [16:38:12:265]: Warning: Local cached package 'C:\WINDOWS\Installer\ce6d56e.msi' is missing.
MSI (s) (90:DC) [16:38:12:265]: User policy value 'SearchOrder' is 'nmu'
MSI (s) (90:DC) [16:38:12:265]: User policy value 'DisableMedia' is 0
MSI (s) (90:DC) [16:38:12:265]: Machine policy value 'AllowLockdownMedia' is 0
MSI (s) (90:DC) [16:38:12:265]: SOURCEMGMT: Media enabled only if package is safe.
MSI (s) (90:DC) [16:38:12:265]: SOURCEMGMT: Looking for sourcelist for product {56EA8BC0-3751-4B93-BC9D-6651CC36E5AA}
MSI (s) (90:DC) [16:38:12:265]: SOURCEMGMT: Adding {56EA8BC0-3751-4B93-BC9D-6651CC36E5AA}; to potential sourcelist list (pcode;disk;relpath).
MSI (s) (90:DC) [16:38:12:265]: SOURCEMGMT: Now checking product {56EA8BC0-3751-4B93-BC9D-6651CC36E5AA}
MSI (s) (90:DC) [16:38:12:265]: SOURCEMGMT: Media is enabled for product.
MSI (s) (90:DC) [16:38:12:265]: SOURCEMGMT: Attempting to use LastUsedSource from source list.
MSI (s) (90:DC) [16:38:12:265]: SOURCEMGMT: Trying source d:\2a2ac35788eea9066bae01\.
MSI (s) (90:DC) [16:38:12:265]: Note: 1: 2203 2: d:\2a2ac35788eea9066bae01\msxml6.msi 3: -2147287037
MSI (s) (90:DC) [16:38:12:265]: SOURCEMGMT: Source is invalid due to missing/inaccessible package.
MSI (s) (90:DC) [16:38:12:265]: Note: 1: 1706 2: -2147483647 3: msxml6.msi
MSI (s) (90:DC) [16:38:12:265]: SOURCEMGMT: Processing net source list.
MSI (s) (90:DC) [16:38:12:265]: Note: 1: 1706 2: -2147483647 3: msxml6.msi
MSI (s) (90:DC) [16:38:12:265]: SOURCEMGMT: Processing media source list.
MSI (s) (90:DC) [16:38:12:296]: SOURCEMGMT: Trying media source F:\.
MSI (s) (90:DC) [16:38:12:296]: Note: 1: 2203 2: F:\msxml6.msi 3: -2147287038
MSI (s) (90:DC) [16:38:12:296]: SOURCEMGMT: Source is invalid due to missing/inaccessible package.
MSI (s) (90:DC) [16:38:12:296]: Note: 1: 1706 2: -2147483647 3: msxml6.msi
MSI (s) (90:DC) [16:38:12:296]: SOURCEMGMT: Processing URL source list.
MSI (s) (90:DC) [16:38:12:296]: Note: 1: 1402 2: UNKNOWN\URL 3: 2
MSI (s) (90:DC) [16:38:12:296]: Note: 1: 1706 2: -2147483647 3: msxml6.msi
MSI (s) (90:DC) [16:38:12:296]: Note: 1: 1706 2: 3: msxml6.msi
MSI (s) (90:DC) [16:38:12:296]: SOURCEMGMT: Failed to resolve source
MSI (s) (90:DC) [16:38:12:296]: MainEngineThread is returning 1612
MSI (c) (DC:58) [16:38:12:296]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (c) (DC:58) [16:38:12:296]: MainEngineThread is returning 1612
=== Verbose logging stopped: 3/28/2012 16:38:12 ===
当我单击 SSIS 的失败状态时，根本没有出现任何日志文件。说实话，我甚至不知道从哪里开始 - 从来没有想到直接从磁盘添加组件会这么麻烦。任何帮助或指示都将不胜感激。如果需要更多详细信息，请询问 - 我很乐意添加它们。
答案1
这些日志文件中最让我印象深刻的部分是：
Source is invalid due to invalid package code (product code doesn't
match)
谷歌找到了与我相关的内容：
答案2
您的错误似乎表明 Windows Installer 缓存文件丢失。
查看此链接：如何恢复丢失的 Windows Installer 缓存文件并解决 SQL Server 更新期间出现的问题