Unable to continue SSIS package after SP2
From time to time we manage our SSIS packages by modifying the configuration file to allow the execution even though the service is stopped. 2 of the packages were working perfectly until we have applied the Service Pack 2 for SQL 2005 couple of weeks ago.
Our DBA team were struggling to resolve this problem and escalated the issue to me, after first assessment and taking changes into consideration since the last successful execution. Even I was at the stage to find what was the problem, then as a last option I was going through the README.HTML for SP2 and found the related entry that has the correction.
Bingo, it has resolved the issue and the notes about the changes since SP2 for SSIS packages is:
SQL Server SP2 resets the value of the registry key HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSDTS\ServiceConfigFile to its default value. This registry key specifies the location of the configuration file for the Integration Services service (MsDtsSrvr.ini.xml). If you had changed the value of this registry key from that of the default location, you must update it again after applying the service pack.
**__________________________________**
SQL Server MVP, Sr. DBA & industry expert.
-
Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it. It is also a power and you will gain by sharing it.