Tuesday, June 12, 2012

Bugs in a Microsoft program? Nawwwww! Couldn't be!

I've been expanding my abilities in SSIS programming, but at present am forced to use the aging Visual Studio 2005 for such endeavors. Well looky, looky if I didn't find a major bug, and thankfully, the fix for it, while playing with a Forloop Container.
The nasty lil' ole bug is in the Script Task Editor, when you go to click on Design Script. The Editor simply closes and leaves you stranded looking at the control flow screen.
The fix, which I found only a couple of mentions of on the web, is to download and install the SQL Server 2005 Service Pack 3 patch.
As of this writing it's still available at: http://www.microsoft.com/en-us/download/details.aspx?id=14752
For my aging XP desktop, SQLServer2005SP3-KB955706-x86-ENU.exe was the file of choice.
So far, I've noticed nothing else screwed up by whatever it installed.
Despite my fears it would, it didn't kill my more recent Native Client that my php scripts depend on.
and my more recent Visual Studios appear to be working fine.

No comments:

Post a Comment