VS2008 crashes when opening Data Flow Task

I recently encountered a problem opening an existing SQL Server Integration Services project in Business Intelligence Development Studio (BIDS aka Visual Studio 2008). When ever I tried to view the Data Flow task for an integration package, Visual Studio would crash. These are the details recorded in the event log:

Faulting application name: devenv.exe, version: 9.0.30729.1, time stamp: 0x488f2b50 Faulting module name: msdds.dll, version: 10.0.30319.1, time stamp: 0x4ba1fee8 Exception code: 0xc0000005 Fault offset: 0x000117f8 Faulting process id: 0x2678 Faulting application start time: 0x01cb9c2181b22022 Faulting application path: C:\Program Files (x86)\Microsoft Visual Studio 9.0\Common7\IDE\devenv.exe Faulting module path: C:\Program Files (x86)\Common Files\microsoft shared\MSDesigners8\msdds.dll Report Id: cba37908-0814-11e0-9fdb-70f1a10159b9

One curious thing I noticed was that the version of the msdds.dll file above is 10.* not 9.*. The file properties also indicated that this was part of Visual Studio 2010.

Not being certain whether the issue was something SQL or VS related, I decided in the absence of more specific information, the most effective approach was most likely to uninstall all the installations of Visual Studio and SQL development components (I didn’t uninstall the SQL instances).

Uninstalling Visual Studio 2010 and 2008, then re-installing BIDS from the SQL 2008 R2 setup replaced the msdds.dll with the original 2008 version.

I was then able to open the SSIS project without any crashing!

Re-installing VS 2010 and the dll was updated back to 10.*, but this time BIDS continues to work properly.

One thing that may be relevant is that for a short time I did have SQL Server codenamed ‘Denali’ installed, so it is possible that something left behind from that might have been the culprit.

This is also a good way to confirm that the LED for your hard disk works properly (and to dream about getting an SSD!)

Extra copper

I had one regret when we did our house extension a few years ago. I’d neglected to install network points next to the TV antenna outlet that I’d put in our family room (what was I thinking!). This meant that the Media Centre has been operating on wireless for the last few months since we relocated it from another room. Not ideal, even though it’s very close to the access point, and I also suspect the wireless drivers are responsible for the Media Centre machine constantly waking up from sleep-mode even though nothing was scheduled to record.

Replacing a skirting board provided an opportunity to hide some cables and remedy the situation. I was initially just going to put one cable in, but then figured that if I’m going to put in one, I might as well put in two. Plus, there’s that special family Christmas present that might appreciate a network connection pretty soon (It rhymes with “Textbox Elect”, and we’re exercising great restraint in not opening the box until December 25th! We ended up getting the 250GB bundle from Harvey Norman – though don’t let them try and sell you a more expensive bundle with a ripoff $50 HDMI cable)

I’d pulled the cables up into the ceiling in the family room a few weeks ago (along with replacing the skirting board), but only yesterday got time to finish the job and run them into our storeroom (where the modem and switches are).

I managed to pull one of the existing cables back up into the ceiling, tie the new cables onto it, then pull them all back down through the wall cavity into the storeroom (if that hadn’t worked, I’d have had to resort to drilling a hole in the ceiling cornice and running some conduit down the wall).

I’d bought a new wallplate and fittings from Jaycar, so I connected those up and hooked in the existing F-type connector. I did discover that the wallplate was probably intended to be mounted vertically (as the network points would only mount sideways), but I can live with that. It’s all hidden behind a sidetable/cabinet anyway.

I then plugged the cables into my 1GBit switch and tested them out in the Media Center. Even though the cable and fittings are only CAT 5e, so far I’ve managed to the existing cables to run at 1Gbit. Not this time, both were only connecting at 100Mb 😢. I didn’t have a lot of spare cable to play with at the wallplate end, but I wondered if I had untwisted the copper pairs too much when I’d hooked them up to the wallplate jacks. I re-did one, taking extra care to keep the pairs twisted until right up to where the wires got punched in. Bingo, 1Gbit! I tried the same with the second, but unfortunately it was still at 100Mbit. Oh well – one out of two isn’t too bad.

Now just to wait patiently for two more weeks until we can play with our XBox 360 and the Kinect controller. Should be a great way to work off Christmas lunch!

My first Windows Phone 7

On Sunday, I dropped by the TeleChoice shop at Marion, and purchased a shiny new Samsung Omnia 7 phone.

I’ve been reading up on Windows Phone 7 handsets since before their release, so felt reasonably well informed as far as what features were present and what was still coming. I ended up choosing the Omnia 7 because a lot of positive comments about the clarity of the Super-AMOLED display, and also that it was compatible Vodafone’s network (my current provider and whose $20/month cap appeals to my budget).

On returning home, I inserted my SIM card and battery, plugged in the charger and turned it on. Starting up was simple and problem-free. I entered in my Windows Live ID, Google GMail, and Facebook details and a short while later, my contacts (aka People Hub) was populated with lots of familiar names. It also connected to my home wireless network without issue.

I’ve sadly been missing out on listening to podcasts since my trip to TechEd (and losing my old phone’s bizarre non-standard earphones), so I was pleased to be able to finally resume my regular habit. I’ve previously made use of the Spokenword feed aggregator, but one downside to using this is that all the podcast files get lumped into what Zune thinks is one single podcast. So I just entered each podcast RSS feed individually. A pity Spokenword doesn’t seem to allow me to export my feed collection, but it wasn’t too tricky to re-enter them.

So far so good. I’ll post an update in a few weeks including how I’m coping on just 100MB/month!